PI60633: SQLCODE=-302 ON DEBUGGING EGL WITH DB2/VSE

Rational Business Developer Fix Pack 2 (9.1.1.2) for 9.1.1

APAR status

• Closed as program error.

Error description

• The user is debugging an EGL program that uses db2 on VSE.
  The debugger gets an sql code -302, when the sql host variable
  length is larger the the sql column size.
  
  
  
  Example:
  
  
  
  record dummySQLRecord type SQLRecord
  
  
  
      CREATOR char(15);  // sql column is defined as char(8)
  
      TNAME   char(18);
  
  
  
  End
  

Local fix

• Match the length of the host variable with the column size
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users accessing VSE DB2 database from RBD EGL Debugger       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * EGL Debugger returns SQL code -302 when a host variable is   *
  * an EGL char variable whose maximum size is larger than the   *
  * corresponding column length in the SQL table. This occurs    *
  * even when the value of the EGL variable is the correct size. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• EGL Debugger now uses correct length for character-type host
  variables used in SELECT query
  

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:

Modules/Macros

• EGLDebug
  

Fix information

• Fixed component name

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R911 PSY

     UP

• R950 PSY

     UP