Regarding Oracle Date
Posted: 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.
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.