Page 1 of 1

Issue with reading Date value from Mainframe using API stage

Posted: Wed Oct 15, 2008 8:36 am
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.

Posted: Wed Oct 15, 2008 3:11 pm
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.