MVSFORUMS.com

Rmravi · Beginner Joined: 24 Jun 2004 Posts: 12 Topics: 5

I am extracting the data from the table A using the following query.

select * from A;

Result will be like this:

x y z
-------
1 2 3
4 5 5
a b c

But I need the column delimiter '|' between the two columns. I need the ruslt like this

1|2|3
4|5|5
a|b|c

If I write the query like this I can get the above result.

NutCracker · Posted: Thu Jul 15, 2004 1:18 am Post subject:

Rmravi · Beginner Joined: 24 Jun 2004 Posts: 12 Topics: 5

But I don't want to select the column list manually in the selection list. (In the real database I am having around 100 columns with different data type).

kolusu · Posted: Thu Jul 15, 2004 4:40 am Post subject:

rmravi,

If you have IBM's DB2 High Performance Unload then you can specify the DELIMTED Format. check this link.

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/INZUGB11/3.2.2.2?SHELF=&DT=20021218173111&CASE=

If your shop does not have the utility then you need to go with Nutcracker's solution.

Hope this helps...

cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Rmravi · Beginner Joined: 24 Jun 2004 Posts: 12 Topics: 5

Thanks Kolusu

Bithead · Posted: Thu Jul 15, 2004 7:58 am Post subject:

You could always run program DSNTEP2 - this gives you similar results.