IBM Support

PI64579: WHEN IN RDZ LPEX COBOL EDIT, ADDING NULL INDICATORS IN THE SQL STATEMENT AND CLICK RUN SQL IN THE CONTEXT MENU, NOTHING HAPPENS

Subscribe

You can track all active APARs for this component.

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

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

More support for: Rational Developer for System z

Software version: 950

Reference #: PI64579

Modified date: 27 October 2016