Fixes are available
APAR status
Closed as program error.
Error description
An SQL error is observed where an 'as' expression is included in an embedded SQL statement in an EGL program. Example columns are defined as per: MAKDNR num(5) {column="MAKDNR"}; MABETRI num(10) {column="MABETRI"}; SBVARTNR num(16) {column="SBVARTNR"}; And then within the SQL statement as: MAKDNR as MAKDNR, MABETRI as MABETRI, SBVARTNR as SBVARTNR Where MABETRI contains the value 91122172 when running the program the following error is thrown ie: EGL0049E An overflow error occurred when assigning a value of 91,122,172 to MAKDNR.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * User that use the EGL SQL select statement that uses the * * expressions expression AS columnName. * **************************************************************** * PROBLEM DESCRIPTION: * * A warning message and subsequent invalid SQL code is * * generated if the user codes the SQL construct "expression AS * * columnName" as part of the SQL select statement. When * * generating, the AS was thought to be an expression by the * * compiler, instead of a keyword and was ignored with a * * warning message. However, both the expression and columnName * * were made into the list of expressions in the select * * statement, resulting in improper SQL code being generated. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
The software was updated with the logic to check for the AS keywords.
Temporary fix
Comments
APAR Information
APAR number
PI70778
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-10-17
Closed date
2019-01-17
Last modified date
2019-01-17
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
RATL BUS DEV
Fixed component ID
5724S5000
Applicable component levels
R901 PSY
UP
R911 PSY
UP
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
19 October 2021