IBM Support

SE63781: RATIONAL DEVELOPER FOR SYSTEM I - USERS NOTICED SPACES ARE INSERTED INTO THE END STATEMENT OF THEIR SQL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In RDi v9.5, if embedded SQL in ILE RPG contains the REPEAT()
    scalar function, then the editor loses track of
    the end of the SQL statement and considers RPG lines after the
    SQL statements as if they were SQL.
    Any declarations and references will not appear in the outline
    view and pressing enter will trigger SQL formatting which
    will do things like interpret a END-PROC as if it was a
    mathematical expression and pad the '-' operator with spaces
    producing
    END - PROC
    
    Workaround:
    Use static outline
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ILE RPG developers using RDi.                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * In RDi 9.5 when editing embedded SQL in ILE RPG containing   *
    * the REPEAT() scalar function, false errors will be reported  *
    * causing the outline view to be incomplete.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    In RDi v9.5, if embedded SQL in ILE RPG contains the REPEAT()
    scalar function, then the editor loses track of the end of the
    SQL statement and considers RPG lines after the SQL statements
    as if they were SQL.  Any declarations and references will not
    appear in the outline view and pressing enter will trigger SQL
    formatting which will do things like interpret a END-PROC as if
    it was a mathematical expression and pad the '-' operator with
    spaces producing END - PROC.
    

Problem conclusion

  • This problem is fixed in the RDi 9.5.0.3 update.
    

Temporary fix

Comments

APAR Information

  • APAR number

    SE63781

  • Reported component name

    RDI RPG AND COB

  • Reported component ID

    5724Y99RC

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-01-13

  • Closed date

    2016-04-22

  • Last modified date

    2016-04-22

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

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

Modules/Macros

  • Outline
    

Fix information

  • Fixed component name

    RDI RPG AND COB

  • Fixed component ID

    5724Y99RC

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSAE4W","label":"Rational Developer for i"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
03 November 2021