Hi,
i am using bulk load @oracle_connector stage and job loading data from seq file to oracle table.my input sample date field data is like this 2015-03-31 00:00:00 .After load data date field is showing like 31.03.15 00:00:00.000. Please help on this how to get same input format after load if i use bulk load.
Thanks
bulk load date issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The date is stored as a date.
What it looks like depends on the Oracle date picture set for your session. You could change that, or you could use TO_CHAR() functions when reporting.
It's in the presentation layer entirely. Your data have almost certainly been loaded correctly.
What it looks like depends on the Oracle date picture set for your session. You could change that, or you could use TO_CHAR() functions when reporting.
It's in the presentation layer entirely. Your data have almost certainly been loaded correctly.
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.
Sorry small correction in my question. if my oracle target table date field datatype DATE then job getting failed if i choose bulk load and if i set to default option create table then for date fields datatype creating timestamp(9).in this case job not failed.is it necessary to change datatype date to timestamp.if i use insert instead of bulk load records loading properly even though datatype date. data volume is >10 million.
Thanks a lot !!!
Thanks a lot !!!
Thanks
REDDY
REDDY
No. But you do need to show us the actual bulk load error message when it is a DATE. Saying it is "getting failed" with no other details doesn't really help us help you, I'm afraid.vinsashi wrote:is it necessary to change datatype date to timestamp.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 36
- Joined: Thu Dec 03, 2009 9:11 pm
- Location: Malaysia
Re: bulk load date issue
hi,
Solution 1
---------------
you can change in the oracle by setting the date format as you wanted by changing the meta data tables.
Solution 2
-----------
Keep the target column as a varchar, use the Iconv and Oconv functionality in the server job to read it to the format as you wanted in the src.
Regards
Naveen
Solution 1
---------------
you can change in the oracle by setting the date format as you wanted by changing the meta data tables.
Solution 2
-----------
Keep the target column as a varchar, use the Iconv and Oconv functionality in the server job to read it to the format as you wanted in the src.
Regards
Naveen
Naveen Kumar
Datastage Consultant
Datastage Consultant