PI64579: WHEN IN RDZ LPEX COBOL EDIT, ADDING NULL INDICATORS IN THE SQL STATEMENT AND CLICK RUN SQL IN THE CONTEXT MENU, NOTHING HAPPENS
Fixes are available
Rational Developer for System z Fix Pack 2 (22.214.171.124) for 9.5.1.
Rational Developer for System z Fix Pack 3 (126.96.36.199) for 9.5.1.
Rational Developer for System z Fix Pack 4 (188.8.131.52) for 9.5.1.
Rational Developer for System z Fix Pack 5 (184.108.40.206) for 9.5.1.
Rational Developer for System z Fix Pack 5 (220.127.116.11) for 9.5.1.
Rational Developer for z Systems Fix Pack 7 (18.104.22.168) for 9.5.1.
Rational Developer for z Systems Fix Pack 8 (22.214.171.124) for 9.5.1.
Rational Developer for z Systems Fix Pack 9 (126.96.36.199) for 9.5.1.
Closed as program error.
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."
RDz passes the SQL statement to Data Studio with indicator variables intact. Data Studio cannot handle indicator variables.
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 V188.8.131.52 Fix Pack which is available from the Recommended Fixes support download page: http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
Reported component name
RATL DEV FOR SY
Reported component ID
NoSpecatt / Xsystem
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
RATL DEV FOR SY
Fixed component ID
Applicable component levels