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

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 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