JR53493: INCORRECT DATA OUTPUT FROM ODBC CONNECTOR FOR THE POSTGRESQL TABLE COLUMN OF DATATYPE CHARACTER VARYING(35000).

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5.0.1 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

APAR status

• Closed as program error.

Error description

• ODBC Connector gives out incorrect or garbled data when reading
  a database column of type character varying(35000) , but if
  length of the database column is less than or equal to 32768
  then the output data is correct.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users who develope datastage jobs using ODBC Connector
  connecting to PostgreSQL database
  ****************************************************************
  PROBLEM DESCRIPTION:
  ODBC Connector gives out incorrect or garbled data when reading
  a database column of type CHARACTER VARYING (35000) , but if
  length of the database column is less than or equal to 32768,
  the output data is correct
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR53493
  ****************************************************************
  

Problem conclusion

• In ODDBC Connector for any database connection it is assumed
  that the maximum length for  varchar column is 32768 and
  anything above it is a LongVarchar, so when 'character varying '
   data type from PostgreSQL is mapped to varchar and the column
  length is more than 32768 the buffers to store data are not
  correctly populated and so the data is corrupted.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R912 PSY

     UP