Variable DataStage for format Date
Posted: Sun Jun 18, 2006 4:07 am
I have a job in the version 4.2 that records the date of the system at format YYYY-MM-DD in the bank Oracle. I used the function Oconv to define the format.
I migrated this job for the version 7.5 and when executing, the date was not recorded. I altered the function Oconv to record at format YYYY-MMM-DD (2006-JUL-01) and it recorded.
The bank Oracle is the same, only the servers DataStage are different. Is there a variable in DataStage that configures the format of the date? For me not to have to alter all the jobs.
Does anybody can me to help?
I migrated this job for the version 7.5 and when executing, the date was not recorded. I altered the function Oconv to record at format YYYY-MMM-DD (2006-JUL-01) and it recorded.
The bank Oracle is the same, only the servers DataStage are different. Is there a variable in DataStage that configures the format of the date? For me not to have to alter all the jobs.
Does anybody can me to help?