IBM Support

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

Subscribe

You can track all active APARs for this component.

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

Temporary fix

Comments

APAR Information

  • APAR number

    PI65526

  • Reported component name

    RATL DEV FOR SY

  • Reported component ID

    5724T0700

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-07-07

  • 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: 9.0

Reference #: PI65526

Modified date: 27 October 2016