IBM Support

PI50107: RATIONAL DEVELOPER FOR SYSTEM Z (RDZ) RUNNING SQL STATEMENT THAT CONTAINS ¬= RESULTS IN ¬ BEING STRIPPED F

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Rational Developer for System z - RDz - v9.1
    The SQL parser removes the caret (^) and right angle (¬) used
    before an =, as part of a NOT EQUAL, in an SQL statement when it
    is execute from within the COBOL editor.
    
    
    To recreate:
    Create an MVS subproject that connects to a host DB2 Database
    Open a PDS that contains a not equal in an sql such as the
    SQL statement below using the COBOL editor:
    
    Click on this statement:
               EXEC SQL
               SELECT EMPNO, FIRSTNME, LASTNAME, WORKDEPT, PHONENO
                FROM DSN8910.EMP
                WHERE SEX ^= 'F'
               END-EXEC.
    
    In the DataStudio SQL Results view the executed command is
    displayed as:
    SELECT EMPNO, FIRSTNME, LASTNAME, WORKDEPT, PHONENO
      FROM DSN8910.EMP
      WHERE SEX = 'F'
    
    The caret symbol, ^, for NOT is stripped from the SQL.
    
    This same SQL statement runs successfully in the DataStudio
    perspective, the carat, ^, is not stripped.
    
    Both <> and != work as expected.  These are the documented ways
    to use not equal in SQL.
    

Local fix

  • Use either <> or != in the SQL statements
    

Problem summary

  • In the case of CARET (^) and COBOL, the COBOL lexer grammar rule
     regarding caret tells the lexer to treat it like a comment.
    

Problem conclusion

  • Need to add special handling for CARET in COBOL Lexical grammar,
     parser, and ExecSQLLexer.
    
    The problem listed in this APAR has been resolved with
    IBM Rational Developer for System z V9.1.1.4 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 number

    PI50107

  • Reported component name

    RATL DEV FOR SY

  • Reported component ID

    5724T0700

  • Reported release

    911

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-10-07

  • Closed date

    2016-09-30

  • Last modified date

    2016-09-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

    RATL DEV FOR SY

  • Fixed component ID

    5724T0700

Applicable component levels

  • R911 PSY

       UP



Document information

More support for: Rational Developer for System z

Software version: 9.1.1

Reference #: PI50107

Modified date: 30 September 2016