JR33993: DB2 CONNECTOR INSERT WRONG VALUE TO THE TARGET TABLE

APAR status

• Closed as program error.

Error description

• DB2 connector issue-
  The wrong data is inserted into the column
   The data is
  truncated with a NULL and then padded with spaces, as can be
  seen in the hex dump
  

Local fix

• using ODBC connector without RCP
  
  This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS 8.0.1 with DTS patch, IS 8.1, all platforms
  ****************************************************************
  PROBLEM DESCRIPTION:
  Users Affected:
  IS 8.0.1 with patches patch_e122936 and patch_JR29796
  IS 8.1 with Connectivity Rollup Patch 1
  (all platforms)
  
  Problem Description:
  When writing to a DB2 database using the DB2 Connector, a
  string column that is followed by a decimal column will be
  updated with the decimal column's data.
  
  Problem Summary:
  When using an insert statement that has a string column followed
  by a decimal column, the DB2 Connector will sometimes use the
  string column's bind buffer for the decimal column's data (being
  retreived from the preceeding stage in the job).  This only
  happens if the string column did not need any codepage
  conversions and the string column's length is greater than the
  length of the decimal column + 2.  (The plus two is for the
  "." and +/- sign.)  The result is that the decimal column's
  data will be inserted into the string column and the decimal
  column.
  
  ****************************************************************
  RECOMMENDATION:
  For IS 8.0.1 users with patches patch_e122936 and patch_JR29796:
  Apply the patch for this APAR.
  
  For IS 8.1 users:
  Apply Connectivity Rollup Patch 2 (which will be released Sept.
  2009)
  
  All users:
  Upgrade to IS 8.5 (once it is released).
  ****************************************************************
  

Problem conclusion

• The allocator for the buffer was declared as "static", thus
  the array's data pointer was not being set to NULL each time.
  The data pointer for the array is now initialized to NULL by an
  explicit call to setArray().  The decimal column will only
  receive its data and the string column will receive the correct
  data.
  

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

• SERVER
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP