PM36585: The SQL results tab in the Data perspective are cleared after each query run

APAR status

• Closed as program error.

Error description

• In Rational Application Developer v8.0 the SQL results will be
  removed from the Data perspective SQL Results view as soon as a
  new script is run from the SQL Editor.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The SQL results will be removed from the Data perspective
  SQL Results view as soon as a new script is run from the SQL
  Editor.  This is happening because the result file is not
  being saved.
  
  Steps to reproduce:
  
  1) In the Data perspective connect to a DB2 or Derby
  database
  2) In the Data Source Explorer view right-click on the
  database and select New SQL script
  3) Run select * from sysibm.SYSDUMMY1. The Result tab is
  displayed on the SQL Results view.
  4) Run it again.  The Result tab is displayed on the SQL
  Results view.
  5) Select first result (from step 3).  The Result tab is
  empty.
  6) Select second result (from step 4). The Result tab is
  empty.
  

Problem conclusion

• A fix was introduced to ensure the result file for the SQL
  query is saved.  The fix for this issue will be in Rational
  Application Developer version 8.0.3.
  

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

  RATL APP DEV WI

• Fixed component ID

  5724J1901

Applicable component levels

• R750 PSN

     UP