IBM Support

SE58260: RDI 9.0.1 AUTO-FORMAT OF SQL DOES NOT ALWAYS WORK IN LPEX WHEN EDITING SQLRPGLE SOURCE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The auto-format of SQL in SQLRPGLE source members does not
    happen when there is a blank line above the SQL.
    

Local fix

  • Delete blank lines above the SQL or insert a commet in the line
    above the SQL and it will format as expected.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: RDi users that format SQL source.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: Auto-formatting of SQL statements       *
    *                      does not work with blank lines in the   *
    *                      statement.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The auto-format of SQL in SQLRPGLE source members does not
    happen when there is a blank line above the SQL.
    

Problem conclusion

  • This problem is fixed in the RDi 9.1.  To turn on SQL
    formatting, go to Window->Preferences->Remote Systems->Remote
    Systems LPEX Editor->IBM i Parsers->ILE RPG->Free-form SQL
    Formatting and enable the 'Automatic formatting' checkbox.
    

Temporary fix

Comments

APAR Information

  • APAR number

    SE58260

  • Reported component name

    RDI RPG AND COB

  • Reported component ID

    5724Y99RC

  • Reported release

    901

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-27

  • Closed date

    2014-05-30

  • Last modified date

    2014-05-30

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

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

Fix information

  • Fixed component name

    RDI RPG AND COB

  • Fixed component ID

    5724Y99RC

Applicable component levels

  • R900 PSN

       UP

  • R901 PSY

       UP

  • R910 PSN

       UP

[{"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.1","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
30 May 2014