JR29185: ISSUE LOADING BINARY DATA TO ODBCEE FOR CHAR(13) FOR BIT DATA

APAR status

• Closed as program error.

Error description

• DS751A/AIX
  
  Customer is getting data corruption If they use ODBC Stage and
  set in Datastage as
  binary and DB datatype as CHAR FOR BIT DATA
  
  It works with a table definition of :
  
  CTF_UNQ_ID CHAR(13) NOT NULL
  
  However it fails with a table definition of
  
  CTF_UNQ_ID CHAR(13) FOR BIT DATA NOT NULL
  
  Engg is suggesting this could be similar to 126131, Please port
  this patch to DS751A/AIX.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ALL
  ****************************************************************
  PROBLEM DESCRIPTION:
  Data corruption on loading binary data using ODBC operator
  ****************************************************************
  RECOMMENDATION:
  Install patch for JR29185
  ****************************************************************
  

Problem conclusion

• Incorrect length specified for binary column, resulting in data
  corruption.
  

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

• R801 PSN

     UP