SE74787: RDI 9.6.0.8 SQL FORMATTING FAILS IF ONE OF THE SQL LINES IS BLANK EXCEPT FOR A SINGLE CHARACTER IN COLUMN 8

APAR status

• Closed as program error.

Error description

• Editing ILE RPG source using the Remote Systems LPEX Editor in
  Rational Developer for i (RDI) 9.6.0.8 embedded SQL statements,
  the SQL statements can be formatted if the preference enabling
  this is checked on. (Preferences > Remote Systems > Remote
  Systems LPEX Editor > IBM I Parsers > ILE RPG > Free-form SQL
  Formatting and check on â ˜Formattingâ ™.) Select the lines, and
  CTRL + SHIFT + F to format.
  
  The SQL formatting fails if one of the SQL lines is blank except
  for a single character in column 8. It either makes no change,
  or drops the content from that line; introducing an error into
  the formatted SQL statement.
  
  In this example, formatting this will drop the closing bracket
  and semi-colon because column 8 content is ignored if there is
  no further content on the line.
  
  ......*..1....+....2....+....3....+....4
      c                  eval     *inlr = *on
        exec sql
        select fld1 into :fldx from table1
        where (fld1 = 'abc'
        )
  

Local fix

• Change the source to move the single character to the line above
  then format the SQL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ILE RPG developers using RDi to edit SQLRPGLE source.        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CTRL+SHIFT+F to format a SQL statement does not work         *
  * correctly.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The format action works incorrectly if one of the lines of a
  multiple-line SQL statement is blank except for column 8.
  

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

• format
  

Fix information

• Fixed component name

  RDI RPG AND COB

• Fixed component ID

  5724Y99RC

Applicable component levels