PI76330: DB2 PREPROCESSOR ERROR IN SQL STATEMENTS THAT HAVE VARIABLE WITH_DATA IN THE VARIABLE NAME

Rational Business Developer Fix Pack 2 (9.5.1.1) for 9.5

APAR status

• Closed as program error.

Error description

• DB2 preprocessor error in sql statements that have variable with
  _DATA in the variable name
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * SQL variables that contain _DATA as part of the name.        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The XML support added a year ago allowed a user to use       *
  * variables for the XML fields. The logic behind this checked  *
  * for the checked for the SQL -DATA field that was created by  *
  * the SQL preprocessor. This field check was not checking for  *
  * the value of -DATA to be at the end of the variable name, so *
  * it also erroneously caught EGL variables used for SQL that   *
  * contained _DATA in the name. Note the _ was changed to - by  *
  * the generator.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The logic has been modified to ensure that the -DATA text is at
  the end of the variable name, which prevents EGL variables from
  being erroneously included. EGL variables have an additional
  -### after them.
  

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

• R950 PSY

     UP