IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

Temporary fix

Comments

APAR Information

  • APAR number

    SE57189

  • Reported component name

    RDI RPG AND COB

  • Reported component ID

    5724Y99RC

  • Reported release

    900

  • Status

    CLOSED SUG

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-29

  • Closed date

    2014-09-05

  • Last modified date

    2014-09-05

  • 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

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSAE4W","label":"Rational Developer for i"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
05 September 2014