PI70778: AN 'AS' EXPRESSION CAUSES EXCEPTION TO BE THROWN IE EGL0049E ANOVERFLOW ERROR OCCURRED

Rational Business Developer Fix Pack 2 (9.0.1.2) for 9.0.1
Rational Business Developer Fix Pack 2 (9.1.1.2) for 9.1.1
Rational Business Developer Fix Pack 2 (9.5.1.1) for 9.5

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