Hi,
We are trying to read records from an Oracle database that contain dates with negative years (as in BC) using Oracle connector. We get the following run time error:
Source_Table,0: Can not convert to framework type timestamp (CC_PXAccessor::setCalendar, file CC_PXAccessor.cpp, line 4,409)
Is there a setting in DataStage that we need to configure to allow negative dates to be processed correctly?
Regards
BC Dates
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you're prepared to use a BASIC Transformer stage or server job, date handling there can handle BC dates correctly out-of-the-box.
I'm not aware of any environment variable that allows negative years to be handled in parallel jobs. Perhaps you could extract the date components (year, month, day) separately, or change the date picture in Oracle's TO_CHAR function so that it produced 55BC rather than -55.
I'm not aware of any environment variable that allows negative years to be handled in parallel jobs. Perhaps you could extract the date components (year, month, day) separately, or change the date picture in Oracle's TO_CHAR function so that it produced 55BC rather than -55.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.