Regarding Oracle Date

devaraj4u · Post by **devaraj4u** » Mon Feb 10, 2003 10:40 am

Hi All,

I am loading data from Oracle Schema and Put it into the OtherSchema.Mapping is Done is Trasform.The Source Schema Columns are mapped to Target Schema.But Some of the Target Schema need some default values because there is NO Match in the Source Schema.How will I assign Default Date(Sysdate equivallent) in DataStage Trasform.

I tried assigning Oconv(@DATE, "D2-")for the DateColumn what I defined.It is compling fine But it is saying the follwing error while running the Job

"[DataStage][SQL Client][ODBC][Oracle][ODBC]Datetime field overflow."

Please help me......

Thanks & Regards,
K.S.Rajan.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 10, 2003 3:25 pm

I'm sure the answer to this is in a reply to another of your posts.
Make the data element TimeStamp in DataStage, so that DataStage generates SQL that includes the TO_DATE function with an appropriate date picture.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

devaraj4u · Post by **devaraj4u** » Mon Feb 10, 2003 4:52 pm

Dear Ray,

I made my datatype as Timestamp.It is working fine now.

Thanks a lot.

Regards,
K.S.Rajan.