View previous topic :: View next topic
|
Author |
Message |
vinay_care
New User
Joined: 22 Sep 2006 Posts: 17
|
|
|
|
hi,
Ineed to load data to a table in DB2 that is unloaded from other DB say oracle DB and it has a different timestamp format, without colon...so how would i do it?
Is thr anyway i can takecare while loading in simple manner.
I mean my table supports with colon, and I need to load having colon,
please suggest.
Thanks,
Vinay |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
You can use SORT product for whatever formatting to be done on unloaded dataset before loading. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you could also format the data properly with the initial unload. |
|
Back to top |
|
|
vinay_care
New User
Joined: 22 Sep 2006 Posts: 17
|
|
|
|
Can I format in the same step? and how? or should i use another step of sort or outrec options, please suggest. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Oracle is rather sophisticated. I would be suprised if the unload utility for oracle does not have an option for unloading for MS-SQL or DB2 format.
otherwise, use sql in the unload to reformat your timestamp with a colon.
I would speak to whoever maintains your other database system. |
|
Back to top |
|
|
vinay_care
New User
Joined: 22 Sep 2006 Posts: 17
|
|
|
|
dbzTHEdinosauer wrote: |
Oracle is rather sophisticated. I would be suprised if the unload utility for oracle does not have an option for unloading for MS-SQL or DB2 format.
otherwise, use sql in the unload to reformat your timestamp with a colon.
I would speak to whoever maintains your other database system. |
how to use sql in the unload, when still I haven't loaded, do you mean after loading into table and then change the data? plz suggest |
|
Back to top |
|
|
|