Datastage conversion of a year in a date: 9999 to 1999.
Posted: Wed May 16, 2001 6:44 am
Hi,
I have got a problem with respect to a high date eg. 31/12/9999. The high date is being used in our system as expiry date for the active users.
Datastage converts all the high dates, when transferred from a flat file to OCI Plugin, into 31/12/1999. This is causing a lot of problems for us.
I am sure someone in the user group could suggest a solution to this problem.
Thanks.
Niranjan
NOTICE
The information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it.
I have got a problem with respect to a high date eg. 31/12/9999. The high date is being used in our system as expiry date for the active users.
Datastage converts all the high dates, when transferred from a flat file to OCI Plugin, into 31/12/1999. This is causing a lot of problems for us.
I am sure someone in the user group could suggest a solution to this problem.
Thanks.
Niranjan
NOTICE
The information contained in this electronic mail message is privileged and confidential, and is intended only for use of the addressee. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by reply transmission and delete the message without copying or disclosing it.