PI65526: IBM RATIONAL DEVELOPER FOR Z SYSTEMS CONTENT ASSIST SHOWS WARNING "GX IS INVALID" IN COBOL EMBEDDED SQL STATEMENTS

Rational Developer for System z Fix Pack 2 (9.5.1.1) for 9.5.1.
Rational Developer for System z Fix Pack 3 (9.5.1.1) for 9.5.1.
Rational Developer for System z Fix Pack 4 (9.5.1.4) for 9.5.1.
Rational Developer for System z Fix Pack 5 (9.5.1.5) for 9.5.1.
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

• When using content assist in IBM Rational Developer for z
  Systems with a COBOL member with embedded SQL statements, when
  GX are the first two letters of the name of the DB2 table with a
  FROM SQL statement, the third and following letters are stripped
  by the SQL parser.
  
  The result is GX when the DB2 table should be AB1234AV.
  
  The error  returned in content assist is "GX is invalid".
  
  As an example, in the member TABLGX,
  
  EXEC SQL
                 SELECT   A.IDENT_PROD
  
                         ,A.VERS_NUM
  
                 INTO    :GXAB1234A.IDENT-PROD
  
                        ,:GXAB1234A.VERS-NUM
  
                 FROM     GXAB1234V A
  
                 WHERE ...
  
  
  Code will be changed in the SQL parser to accommodate this
  naming convention.
  

Local fix

• If the table will allow, add quotes to the table name such as
  "GXAB1234V".
  

Problem summary

• RDz's SQL parser incorrectly parses table names starting with
  'GX' and shows a "GX is invalid" warning.
  

Problem conclusion

• Modified SQL parser to correctly parse table names starting with
   'GX'.
  
  The problem listed in this APAR has been resolved with
  IBM Rational Developer for z Systems V9.5.1.2 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

• R951 PSY

     UP