SE73084: RDI 9.6.0.7 EDITING SQLRPGLE SOURCE WITH EMBEDDED SQL THE EDITORMAY INCORRECTLY REPORT SYNTAX ERRORS FOR VALID SQLRPGLE 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 report syntax errors for valid
  SQLRPGLE source.
  
  The problem occurs when the source has a complex SQL statement
  with a CASE nested within a CASE, resulting in two END words in
  sequence at the end of the two CASEs. This causes a problem in
  the SQL and RPG parsing, leading the editor to not recognize the
  correct end of the SQL statement. The result is incorrect token
  coloring in the editor, error annotations in the editor, and an
  incorrect Outline view.
  
  For example:
  CASE WHEN ... ELSE CASE WHEN ... ELSE ... END END
  

Local fix

• Enclose the nested CASE in brackets, so that the two ENDs are
  separated by a closing bracket.
  
  For example to correct the sample in the problem description:
  CASE WHEN ... ELSE (CASE WHEN ... ELSE ... END) END
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ILE RPG developers using RDi to edit SQLRPGLE source.        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Embedded SQL with a CASE â ¦ END within a CASE â ¦ END       *
  * incorrectly diagnosed with syntax errors.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The adjacent END END tokens from the nested CASE was incorrectly
  parsed, leading to invalid errors.
  

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

• syntaxCh
  

Fix information

• Fixed component name

  RDI RPG AND COB

• Fixed component ID

  5724Y99RC

Applicable component levels