Fixes are available
Rational Developer for System z Fix Pack 2 (9.5.1.1) for 9.5.1.
Rational Developer for System z Fix Pack 3 (9.5.1.1) for 9.5.1.
Rational Developer for System z Fix Pack 4 (9.5.1.4) for 9.5.1.
Rational Developer for System z Fix Pack 5 (9.5.1.5) for 9.5.1.
Rational Developer for System z Fix Pack 5 (9.5.1.6) for 9.5.1.
Rational Developer for z Systems Fix Pack 7 (9.5.1.7) for 9.5.1.
Rational Developer for z Systems Fix Pack 8 (9.5.1.8) for 9.5.1.
Rational Developer for z Systems Fix Pack 9 (9.5.1.9) for 9.5.1.
Rational Developer for z Systems Fix Pack 10 (9.5.1.10) for 9.5.1.
Rational Developer for z Systems Fix Pack 11 (9.5.1.11) for 9.5.1.
Rational Developer for z Systems Fix Pack 12 (9.5.1.12) for 9.5.1.
APAR status
Closed as program error.
Error description
When in Rational Developer for System z 9.5.1 LPEX COBOL edit, adding null indicators (e.g. like :NOPPES* below) in the SQL statement and click Run SQL in the context menu, nothing happens After removing these null indicators the "Host Variable Values" dialog is shown as expected. EXEC SQL UPDATE USER184.P49622 SET ASSOC_NAME = :DCLP49622.ASSOC-NAME :NOPPES-ASSOC-NAME ,ASSOC_GENDER = :DCLP49622.ASSOC-GENDER :NOPPES-ASSOC-GENDER ,ASSOC_HIRE_DTE = :DCLP49622.ASSOC-HIRE-DTE :NOPPES-ASSOC-HIRE-DTE ,ASSOC_DEPT_ID = :DCLP49622.ASSOC-DEPT-ID :NOPPES-ASSOC-DEPT-ID ,ASSOC_PHONE_EXT = :DCLP49622.ASSOC-PHONE-EXT :NOPPES-ASSOC-PHONE-EXT ,ASSOC_START_SALRY = :DCLP49622.ASSOC-START-SALRY ,ASSOC_USER_ID = :DCLP49622.ASSOC-USER-ID ,ASSOC_ACTIVITY_TSP = CURRENT_TIMESTAMP WHERE ASSOC_ID = :DCLP49622.ASSOC-ID END-EXEC. When copying and pasting the SQL statement in Data Studio, it complains and showed this error in the log: "DB2 for z/OS: Unexpected text ":NULL" encountered."
Local fix
Problem summary
RDz passes the SQL statement to Data Studio with indicator variables intact. Data Studio cannot handle indicator variables.
Problem conclusion
Stripped indicator variables from SQL before sending to Data Studio. The problem listed in this APAR has been resolved with IBM Rational Developer for z Systems V9.5.1.2 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 number
PI64579
Reported component name
RATL DEV FOR SY
Reported component ID
5724T0700
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-06-21
Closed date
2016-10-27
Last modified date
2016-10-27
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
R951 PSY
UP
Document Information
Modified date:
16 October 2021