PH62823: MILLISECONDS CORRUPTED USING ITX JDBC ADAPTER TO READ TIME DATA FROM SYBASE DATABASE

APAR status

• Closed as program error.

Error description

• When using IBM Sterling Transformation Extender (ITX) to read
  time data (with milliseconds) from a Sybase database using the
  JDBC adapter, if the first digit of the milliseconds is a 0,
  then it is possible that the decimal point would be placed in
  the wrong location, causing the data to become invalid.  For
  example,
  '06:17:29.013' could become '06:17:290.13'.
  

Local fix

• ITXCQ - ITX00062615
  PB / PB
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender jdbc users using microseconds in
  tables.
  
  Problem Description:
  Milliseconds corrupted using ITX JDBC adapter.
  
  Platforms Affected:
  All
  

Problem conclusion

• Code updated for Milliseconds in timestamp.
  
  Applies to:
  10.1.2.1
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from Passport
  Advantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

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

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels