SE73104: RDI 9.6.0.7 EDITING SQLRPGLE SOURCE WITH EMBEDDED SQL THE EDITORMAY INCORRECTLY INTERPRET THE SOURCE

APAR status

• Closed as program error.

Error description

• When editing SQLRPGLE source with embedded SQL using the Remote
  Systems LPEX Editor in Rational Developer for i (RDI) 9.6.0.7
  the editor may incorrectly interpret the source. The problem
  occurs when the source has an embedded  SQL statement with the
  word CASE inside a quoted string within the SQL statement.  The
  code scan may then not correctly recognize the end of the SQL
  statement. This can cause incorrect token coloring in the
  editor, error annotations in the editor, and an incorrect
  Outline view.
  
  For example:  exec sql select IBMREQD as "Case Count" from
  sysibm.sysdummy1;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ILE RPG developers using RDi to edit SQLRPGLE source.        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Embedded SQL with the word CASE inside a literal constant    *
  * value is incorrectly interpreted as being a CASE clause.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The word CASE appearing in a character constant string (eg.
  â ˜my case countâ ™) in the embedded SQL statement is
  incorrectly interpreted as a SQL CASE clause; causing errors in
  the further interpretation of the statement.
  

Problem conclusion

• This problem is fixed in the RDi 9.6.0.11 update.
  Product web page:
  https://www.ibm.com/us-en/marketplace/rational-developer-for-i
  Fix List and download link:
  http://www.ibm.com/support/docview.wss?uid=swg27038481
  

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:

Modules/Macros

• SQL
  

Fix information

• Fixed component name

  RDI RPG AND COB

• Fixed component ID

  5724Y99RC

Applicable component levels