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

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

• 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

• Modified SQL parser to correctly handle qualified PL/I
  references.
  
  The problem listed in this APAR has been resolved with
  IBM Rational Developer for z Systems V9.5.1.6 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

  DEV FOR Z SYS

• Fixed component ID

  5724T0700

Applicable component levels

• R951 PSY

     UP