Date Function in Datastage
Posted: Fri Nov 13, 2009 4:00 am
I need to insert a Date ('31-dec-9999') into my oracle database which has a datatype as Date. How do i do it using Datastage?
Page 1 of 1
Posted: Fri Nov 13, 2009 4:08 am
What datatype are you using to define it the DS
Posted: Fri Nov 13, 2009 4:16 am
DataStage server does not bother about datatypes.
What did you try so far ? What issues are you facing ?
It is better to post specific issues than ask open questions.
You may better refer to the documents before posting.
What did you try so far ? What issues are you facing ?
It is better to post specific issues than ask open questions.
You may better refer to the documents before posting.
Posted: Fri Nov 13, 2009 7:29 am
You do it the same way you would do it anywhere else, with the help of a properly configured TO_DATE() function. The stage can automatically generate that for you.
Posted: Fri Nov 13, 2009 2:43 pm
If you specify Date as the Data Element, DataStage will expect an internal format date.