Issue with reading Date value from Mainframe using API stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
devanathan_82
Participant
Posts: 3
Joined: Tue Oct 14, 2008 10:56 am
Location: Minneapolis

Issue with reading Date value from Mainframe using API stage

Post by devanathan_82 »

Using API stage to ready from IBM DB2 (Z/OS). When there are date values of 0001-01-01 the records are skipped by Datastage saying the minimum date value should be 0001-01-03. Is there a patch or some setting to get datastage to read this data properly.
Top
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Can you please post the actual error message? I suspect that this is a DB2 restriction rather than a DataStage one; your DBA may therefore be able to assist.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”