View previous topic :: View next topic
|
Author |
Message |
shuklas
New User
Joined: 21 Dec 2006 Posts: 20 Location: London
|
|
|
|
Hi All,
I am using DSNTIAUL for unloading tables from DB2, but I do not know how to do unload in CSV format.
If anyone of you have idea, how this can be done please let me know, else I have to go for BMC unload. I want to use DSNTIAUL as this gives me flexibility to do unload of n<100 tables in a single JCL with minimal effort.
Regards,
Shuklas |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
If you mean to use delimiters, then UNLOAD utility can do it. Or in TIAUL you can try concatenating your delimiters to your columns. |
|
Back to top |
|
|
Khushboo.goel
New User
Joined: 22 Feb 2011 Posts: 19 Location: india
|
|
|
|
Hi,
Even I m facing a similar problem.
using DSNTIAUL for unloading tables from DB2, but I do not know how to do unload in CSV format.. could you please help me out. |
|
Back to top |
|
|
Khushboo.goel
New User
Joined: 22 Feb 2011 Posts: 19 Location: india
|
|
|
|
this is urgent.. can anybody help urgently.. thanks |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
This is a VOLUNTEER forum -- we don't do urgent. You'll be answered when people who know have the time to respond -- which could be minutes or hours or days. If you're that much in need of assistance, either talk to your site support group or hire a consultant to provide the urgent assistance. |
|
Back to top |
|
|
Khushboo.goel
New User
Joined: 22 Feb 2011 Posts: 19 Location: india
|
|
|
|
Ok thanks.. I will for someone to respond... |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi Khushboo,
Wanderer has already replied to your question,
wanderer wrote: |
If you mean to use delimiters, then UNLOAD utility can do it. Or in TIAUL you can try concatenating your delimiters to your columns. |
You can use UNLOAD utility to unload in CSV format, example in DB2 V9 Utility Reference manual --> Unload --> Samples --> Example 9
If you want to use DSNTIAUL, you have to concatenate delimiters in your SQL statement like,
Code: |
select col1||';'||col2||';'col3 from table |
Thanks,
Sushanth |
|
Back to top |
|
|
|