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

Rational Test Virtualization Server Fix Pack 1 (8.5.1.1) for 8.5.1
Rational Performance Test Server Fix Pack 1 (8.5.1.1) for 8.5.1
Rational Test Virtualization Server Fix Pack 2 (8.5.1.2) for 8.5.1
Rational Performance Test Server Fix Pack 2 (8.5.1.2) for 8.5.1
Rational Integration Tester Fix Pack 2 (8.5.1.2) for 8.5.1
Rational Test Virtualization Server Fix Pack 3 (8.5.1.3) for 8.5.1
Rational Integration Tester Fix Pack 3 (8.5.1.3) for 8.5.1
Rational Integration Tester Fix Pack 4 (8.5.1.4) for 8.5.1
Rational Test Virtualization Server Fix Pack 4 (8.5.1.4) for 8.5.1
Rational Performance Test Server Fix Pack 5 (8.5.1.5) for 8.5.1
Rational Test Virtualization Server Fix Pack 5 (8.5.1.5) for 8.5.1
Rational Integration Tester Fix Pack 5 (8.5.1.5) for 8.5.1
Rational Performance Test Server Fix Pack 3 (8.5.1.3) for 8.5.1
Rational Performance Test Server Fix Pack 4 (8.5.1.4) for 8.5.1

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 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