Troubleshooting
Problem
Using IBM Rational Business Developer, COBOL programs generated for Enterprise Generation Language (EGL) source programs, fail when prepared, with either SQLCODE -206 or -113, if there are SQL statements that contain the minus operator without spaces around it.
Symptom
These programs were migrated from IBM VisualAge Generator. The COBOL programs generated by IBM VisualAge Generator did not have this problem.
- For COBOL programs generated for z/OS, the SQLCODE =-206 occurs on the bind step and following is an example of that error:
- For COBOL programs generated for iSeries, the SQL0113 error is found in the build listing. The following is an example of that error:
DSNX105I -DBT1 BIND SQL WARNING
USING VGGEN AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=xxxxxxxx
STATEMENT=nnnn
SQLCODE=-206
SQLSTATE=42703
TOKENS=KUMULE_BORC-KUMULE_ALAC
Note that TOKENS has an embedded "-" (hyphen without the double quotes) character which should be treated as the minus operator.
- SQL0113 30 16236 Position 33 POVTTCPT-POVHTAXE-PO9ACCES contains a character that is not allowed or does not contain any characters.
which points to the following line in the COBOL source:
16236 FOR select SUM(POVTTCPT-POVHTAXE-PO9ACCES) from
[{"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"COBOL Generation","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.0;7.1;7.5","Edition":"","Line of Business":{"code":"LOB70","label":"Z TPS"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
02 August 2018
UID
swg21421529