PM15638: sql error -302 when updating sql record

APAR status

• Closed as program error.

Error description

• User is running a Cobol program generated with Rational Business
  Developer 7.5.1.5
  
  The program performs a "get" on an sql record which has a
  VARCHAR
  column. At runtime, an INSERT fails with sql code -302
  because the length assigned to the host variable does not
  match the actual column length.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The problem was that for get next sql statements, the logic
  didn't detect all variable length sql variables, and because
  of that avoided adding the additional logic to clear the
  trailing end of the variable length field to spaces. When
  this uncleared variable was moved around by the program's
  logic, garbage was moved along with it. When the logic to
  replace the sql field was finally triggered, it would scan
  the field from the end, backwards, counting trailing spaces
  to determine the variable length to tell sql. The garbage at
  the end of the field was causing the length to be invalid.
  

Problem conclusion

• Software updated. Fixtest available.
  

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

• R751 PSN

     UP