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

Rational Developer for System z Fix Pack 1 (9.1.1.4) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.5) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.6) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.7) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.8) for 9.1.1
Rational Developer for System z Fix Pack 9 (9.1.1.9) for 9.1.1

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