PI50107: RATIONAL DEVELOPER FOR SYSTEM Z (RDZ) RUNNING SQL STATEMENT THAT CONTAINS Â¬= RESULTS IN Â¬ BEING STRIPPED F
Fixes are available
Rational Developer for System z Fix Pack 1 (126.96.36.199) for 9.1.1.
Rational Developer for System z Fix Pack 1 (188.8.131.52) for 9.1.1.
Rational Developer for System z Fix Pack 1 (184.108.40.206) for 9.1.1.
Rational Developer for System z Fix Pack 1 (220.127.116.11) for 9.1.1.
Rational Developer for System z Fix Pack 1 (18.104.22.168) for 9.1.1
Closed as program error.
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.
Use either <> or != in the SQL statements
In the case of CARET (^) and COBOL, the COBOL lexer grammar rule regarding caret tells the lexer to treat it like a comment.
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 V22.214.171.124 Fix Pack which is available from the Recommended Fixes support download page: http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
Reported component name
RATL DEV FOR SY
Reported component ID
NoSpecatt / Xsystem
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
RATL DEV FOR SY
Fixed component ID
Applicable component levels