PI28736: RATIONAL DEVELOPER FOR SYSTEM Z (RDZ): ERROR 'ERROR TOKEN' IS WRONGLY SHOWN WHEN SQL STATEMENT CONTAINS INCLUDE STATEMENT.

Rational Developer for System z Fix Pack 6 (9.0.1.6) for 9.0.1
Rational Developer for System z Interim Fix 1 for 9.0.1.6
Rational Developer for System z Fix Pack 7 (9.0.1.7) for 9.0.1

APAR status

• Closed as program error.

Error description

• Rational Developer for System z - RDz - v9.0.1.2
  
  COBOL parser sets an error when an SQL statement contains an
  INCLUDE statement.
  
  Re-creation steps:
  
  For instance, use the following code:
  
  1    EXEC SQL
  2          DECLARE VIEW01_KEY01_TXL_CSR CURSOR WITH HOLD FOR
  3          SELECT
  4          EXEC SQL
  5              INCLUDE COPY001
  6          END-EXEC
  7          FROM
  8          TXL_HHA
  9          WHERE
  10         EXEC SQL
  11             INCLUDE COPY002
  12         END-EXEC
  13         FOR UPDATE OF
  14         EXEC SQL
  15             INCLUDE COPY003
  16         END-EXEC
  17    END-EXEC.
  
  Once opened, lines 5 will be marked with the following error
  message:
  "ERROR_TOKEN" unexpected tokens ignored
  

Local fix

Problem summary

• Multiple INCLUDE statements within a EXEC SQL statement causes
  error.
  

Problem conclusion

• Adjusted the functions to cover that use case.
  
  The problem listed in this APAR has been resolved with
  IBM Rational Developer for System z V9.0.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

  RATL DEV FOR SY

• Fixed component ID

  5724T0700

Applicable component levels

• R901 PSY

     UP