IBM Support

PM16459: SQLCODE -206 or -113 preparing EGL generated COBOL programs with SQL statements that use the minus operator

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Rational Business Developer V7.5.1.5:
    
    SQL errors are received preparing EGL generated COBOL programs
    with SQL statements that contain the minus operator without any
    spaces around the operator and the operands.  Possible errors
    are:
    
    1) SQLCODE -113 where the message states:
    
    SQL0113N identifier contains a character that is not allowed or
    does not contain any characters.
    
    2) SQLCODE -206 where the message states:
    
    SQL0206N name is not valid in the context where it is used.
    
    The solution is to add the ADDSPACESAROUNDSQLHYPHENS=YES
    symbolic parameter to the build descriptor used to generate the
    COBOL for these programs.
    
    This information needs to be added to the VisualAge to EGL
    Migration Guide.
    
    The following is the URL to a technical document that discusses
    this issue:
    
    http://www-01.ibm.com/support/docview.wss?uid=swg21421529?myns=s
    wgrat?mynp=OCSSXJ7E?mync=R
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Needed SQL error codes in doc
    

Problem conclusion

  • Added codes and added note to intro in version 8.0.1
    documentation
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM16459

  • Reported component name

    RBD EGL FOR COB

  • Reported component ID

    5724S5001

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-14

  • Closed date

    2010-12-07

  • Last modified date

    2010-12-07

  • 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

    RBD EGL FOR COB

  • Fixed component ID

    5724S5001

Applicable component levels

  • R751 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
07 December 2010