SE57189: RDI 9.0 AUTOMATIC SQL FORMATTING IGNORES CODE PUSHED BEYOND THE FILE RECL

APAR status

• Closed as suggestion for future release.

Error description

• When the automatic SQL formatting is enabled if a long line in
  an SQL statement is edited in an RPGLE /free block that pushes
  the right-most characters of the line beyond the record length
  (RECL) of the source then when the cursor leaves the line and
  the line is formatted it is split at the RECL position leaving
  some source beyond the RECL column and formatting the rest.  The
  formatter should process the whole line to bring all the source
  and not ignore the characters that are beyond the RECL column.
  

Local fix

• Turn off the Automatic SQL formatting in RPG and manually
  format long lines.  The setting for this is in the preferences
  on panel Remote Systems > Remote Systems LPEX Editor > IBM i
  Parsers > ILE RPG > Free-form SQL Formatting
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * RDi users that use automatic SQL formatting.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The automatic SQL formatting ignores code pushed beyond the  *
  * record length.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the automatic SQL formatting is enabled and a free-form SQL
  statement that pushes the right-most characters of the line
  beyond the record length (RECL) is edited, the formatted line it
  is split at the RECL position leaving some source beyond the
  RECL column and formatting the rest.
  

Problem conclusion

• A Request for Enhancement has been submitted to enhance this
  support.  For more information, see
  http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&C
  R_ID=56331.
  

Temporary fix

Comments

• For more information, see
  http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&C
  R_ID=56331.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels