PK77464: When in VAG compatibility mode, a SQL singlerow select is not po pulating the EGL variables when it receives a -811 SQL code

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