IBM Support

PI80129: IBM RATIONAL DEVELOPER FOR Z SYSTEMS (RDZ/IDZ) RTSC SHOWS FALSE SQL ERRORS SHOWN IN PL/I EDITOR

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • IBM Rational Developer for System z - RDz - v9.5.1
    IBM Developer for z Systems - IDz - v14
    
    The real time syntax checker (RTSC) flags some SQL lines
    lines as errors in the PLI editor when they are correct
    
    
    Steps to recreate:
    In the associated property group for PlI member PLISAMP2
     the following options are set:
    
    On PLI tab:
    Procedures and steps > ELAXFPL1 > PLI > compiler options:
     +DD:OPTIONS OR('!') NOT('ˆ') MACRO
    
    Local compiler > SQL options
    Check the checkbox "Source contains EXEC SQL statements"
    
    Open member in PLI editor that contains:
    dcl MyCity     char(32);
    dcl MyCountry  char(32);
    
      dcl 1 TEST,
            2 LEVEL2,
            3 CITY      char(32),
            3 COUNTRY   char(32);
    
    MyCity = 'RTP';
    MyCountry = 'USA';
    
    
     EXEC SQL
        DECLARE C4 CURSOR WITH RETURN WITH HOLD FOR
           SELECT * FROM TEST.CITYTABLE
            WHERE CITY=:TEST.LEVEL2.CITY AND
            ( COUNTRY=:TEST.LEVEL2.COUNTRY OR
            COUNTRY=:TEST.COUNTRY)
    
    The TEST.LEVEL2.x variables in the SQL statements are flagged
    with the following errors:
    
      WHERE CITY=:TEST.LEVEL2.CITY has "misplaced construct"
      COUNTRY=:TEST.LEVEL2.COUNTRY  has "colon parameter' expected
    

Local fix

  • none available
    

Problem summary

  • RDz's SQL parser incorrectly handles qualified PL/I references.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI80129

  • Reported component name

    DEV FOR Z SYS

  • Reported component ID

    5724T0700

  • Reported release

    951

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-18

  • Closed date

    2017-11-30

  • Last modified date

    2017-11-30

  • 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

    DEV FOR Z SYS

  • Fixed component ID

    5724T0700

Applicable component levels

  • R951 PSY

       UP



Document information

More support for: Rational Developer for System z

Software version: 951

Reference #: PI80129

Modified date: 30 November 2017