IBM Support

PM73836: PREPARATION OF SQL QUERY DIFFICULT WITH ARRAY INDEX IN TAG SINCE"TEST" RESULTS ARE NOT AVAILABLE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Create a tag, and a piece of SQL using that tag, and then use
    the "Test" button to check that it works. You will be
    prompted for a value, and then results will appear along with an
    "Overwrite existing results" button. Overwrite the
    results so the step passes. All is well.
    
    You can now modify that step to use an array element instead of
    a simple tag, and all is still well. Now click "Test" and enter
    a value for the tag array element. The results never appear.
    
    If you go through the same steps starting with a tag array
    element then it is impossible to overwrite the results without
    running the test (which is normally undesirable at this stage).
    
    Example SQL:
    select sysdate - %%R1%% from dual
    
    or
    
    select sysdate - %%R1[0]%% from dual
    
    HISTORICAL INFORMATION:
    This issue was previously logged under GHT5-22922.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Rational Integration Tester users working with SQL Query     *
    * actions.                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When working with a SQL Query action, users are normally     *
    * able to use the 'Test' button to check the results of the    *
    * query, and if so desired, write the result into the expected *
    * results of the action. When the query contains a reference   *
    * into a list tag, the 'Test' of the query failed to retrieve  *
    * the expected results.                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Rational Integration Tester version 8.5.1.1 or    *
    * above.                                                       *
    ****************************************************************
    

Problem conclusion

  • A fix for this issue was included in Rational Integration Tester
    version 8.5.1.1. With this fix it is now possible to test the
    results of a SQL Query action, even if the query uses list tags.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM73836

  • Reported component name

    GREEN HAT TESTE

  • Reported component ID

    5725G79GT

  • Reported release

    540

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-09-27

  • Closed date

    2014-01-06

  • Last modified date

    2014-01-06

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    GREEN HAT TESTE

  • Fixed component ID

    5725G79GT

Applicable component levels

  • R540 PSN

       UP



Document information

More support for: Green Hat Tester

Software version: 5.4

Reference #: PM73836

Modified date: 06 January 2014