A fix is available
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 number
PI76330
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
2017-02-09
Closed date
2019-01-21
Last modified date
2019-01-21
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
21 January 2019