JR40256: ORAOCI should allow a timestamp where a date is expected

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• Allowing one to use a timestamp where a date is expected.
  This works in DS7.5.2
  and expected to continue to work in IS8.5
  
  The job with Tochar( Date , "YYYY-MM-DD HH24-MM-SS" )
  is working fine in DataStage 7.5.2 and  failing in IS8.5
  

Local fix

• Either the TO_CHAR needs to be changed so that a valid DATE
  value (no time) is produced, or the DataStage column needs to be
  changed to a TIMESTAMP.
  

Problem summary

• ORAOCI plugin expects Dates to contain only Date information
  (e.g. "YYYY-MM-DD").  The extraneous information included in a
  timestamp pattern causes "OCI DATE conversion failed"
  

Problem conclusion

• If there is a blank space in the string, truncate it there
  before conversion to date value.
  

Temporary fix

• Use a Timestamp column with timestamp pattern, or use a Date
  column with a date pattern.
  

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

• R850 PSY

     UP