My job is
sequential file------>dynamic RDBMS
I have imported all the input data into the sequential file. These input data contains the date column. I have set the data type as 'date' for date column.
But if i transferring the input data from sequential file to dynamic RDBMS.
Data type has been changed as 'Time stamp' for date column in dynamic RDBMS, which is my target file. But i want to make the data type as 'date'.
How to change it.
Pls provide me the solution
Date format
Moderators: chulett, rschirm, roy
-
mcs_murali83
- Participant
- Posts: 23
- Joined: Sat Sep 29, 2007 6:05 am
- Location: Datastage
- Contact:
Date format
Murali
-
mcs@rajesh
- Participant
- Posts: 46
- Joined: Mon Sep 24, 2007 12:37 am
- Location: INDIA
Hi pal,
whenever we try to read any record of data from any database there will be a datatype mismatch in the date colum bcoz the database itself will maintain its own datatype for the sake of its conviniency the only way to change the datatype wud be using the identical datatype of the database or using a modify stage... bye..
whenever we try to read any record of data from any database there will be a datatype mismatch in the date colum bcoz the database itself will maintain its own datatype for the sake of its conviniency the only way to change the datatype wud be using the identical datatype of the database or using a modify stage... bye..