APAR status
Closed as program error.
Error description
When developing programs in Rational Business Developer v7.1.0.1 and VAG compatibility mode is enabled, an SQL singlerow select is not populating the EGL variables when it receives a -811 SQL return code.
Local fix
Problem summary
The problem is that the application is actually getting a SQL error back (code=-811 state=21000) meaning that the single row select statement actually produces more than 1 row and DB2 issues an error in this event. Even though there is an error from DB2, it seems that DB2 still populates the SQL host variables with the 1st row's data. The difference between VAG and EGl, is that VAG actually used the VAG variables as the SQL host variables and when this SQL call was issued, the VAG variables got updated despite the error. With EGL, the SQL host variables are temporary variables that are not the EGL variables. EGL would then check the SQL error code and only move in the values to the EGL variables, if there was no error. Because of that, those EGL variables did not change. A fix has been made to check for this specific error code when using a single row select is made, and if detected, the move of the SQL host variable still takes place, and then the error is issued. This will only happen with in VAG compatibility mode.
Problem conclusion
Software updated
Temporary fix
Comments
APAR Information
APAR number
PK77464
Reported component name
RATL BUS DEV
Reported component ID
5724S5000
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-12-12
Closed date
2009-03-20
Last modified date
2009-03-20
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
R700 PSN
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":"7.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
20 March 2009