PI26958: RATIONAL DEVELOPER FOR SYSTEM Z V9.1 - RUN SQL NOT WORKING FOR DECLARE CURSOR

Rational Developer for System z Interim Fix 1 for 9.1.1
Rational Developer for System z Interim Fix 2 for 9.1.1
Rational Developer for System z Fix Pack 1 (9.1.1.1) for 9.1.1.
Rational Developer for System z Interim Fix 1 for 9.1.1.1
Rational Developer for System z Interim Fix 2 for 9.1.1.1
Rational Developer for System z Fix Pack 1 (9.1.1.2) for 9.1.1.
Rational Developer for System z Interim Fix 1 for 9.1.1.2
Rational Developer for System z Interim Fix 2 for 9.1.1.2
Rational Developer for System z Fix Pack 1 (9.1.1.3) for 9.1.1.
Rational Developer for System z Interim Fix 1 for 9.1.1.3
Rational Developer for System z Fix Pack 1 (9.1.1.4) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.5) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.6) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.7) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.8) for 9.1.1
Rational Developer for System z Fix Pack 9 (9.1.1.9) for 9.1.1

APAR status

• Closed as program error.

Error description

• When using the Data Studio V4.1 and Rational Developer for
  System z V9.1 integration feature, the "Run SQL" action is not
  working for DECLARE CURSOR with cursor variable names containing
  a dash. If the user highlights the entire EXEC SQL DECLARE
  EMPLOYEE-LOOKUP CURSOR FOR SELECT statement and select Run SQL,
  there is no response and no prompt to fill in the host variable.
  

Local fix

• Until the RDz fix is available, the user can remove the dash
  from cursor name for testing purposes and then reinsert the dash
  before saving the COBOL source.
  

Problem summary

• Hyphen characters were not properly processed when performing
  Run SQL from COBOL, PL/I or LPEX editors.
  

Problem conclusion

• The problem listed in this APAR has been resolved with
  IBM Rational Developer for System z V9.1.1.1 Fix Pack which
  is available from the Recommended Fixes support download page:
  http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
  

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 DEV FOR SY

• Fixed component ID

  5724T0700

Applicable component levels

• R911 PSY

     UP