I am trying to load DATES using oracle enterprise using a PX job. I have dates comming in a 'yyyyddmm' format. I converted that to DATE in transformer using StringtoDate(inputlink, '%yyyy%mm%dd'). Its not able to but load the data using oracle enterprise stage.
Thnx,
BULK loading DATE data type error
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 42
- Joined: Wed Aug 18, 2004 2:49 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is an Oracle error. To find out more execute the following command on the DataStage server.
Basically, however, your data (column R263_FISCAL_DATA_END) contains at least one date with the year less than -4713, zero, or larger than +9999. This is not acceptable to Oracle when storing as a DATE data type.
My guess is that you have a zero date as a default; you need to intercept this and provide an alternative default.
Code: Select all
oerr ORA 1841
My guess is that you have a zero date as a default; you need to intercept this and provide an alternative default.
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.