JR31655: TRANSFORMER TIMESTAMPTOSTRING() NOT CONVERTING TIMESTAMPS CORRECTLY

APAR status

• Closed as program error.

Error description

• Transformer TimestampToString() not converting timestamps
  correctly.  Inserting into Sybase using the ODBC stage
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of ODBC Common Connector Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  Date, Time and Timestamp fields are getting default values
  (1900-01-01 12.00 AM) when inserting through ODBC Common
  Connector to Sybase database.
  ****************************************************************
  RECOMMENDATION:
  Apply this APAR.
  The fix has been included in the IS 8.1 FP1. Apply the FixPack1
  for IS 8.1.
  ****************************************************************
  

Problem conclusion

• The original values will be inserted into the fields of Date,
  Time and Timestamp fields.
  

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

• 801Y
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP