MVSFORUMS.com

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Hi all

in db2 I want to write a SQL that can take the values from a Table which has multiple rows in it and want to convert them to as multiple columns.

For example the table data from table A is as follows

Input

A
B
C
D

Output should be display as

A B C D

Like this

Could you please help me in this

Thanks
Coolguy

kolusu · Posted: Tue Aug 04, 2009 12:32 pm Post subject:

coolguy,

what happens if you have more than 750 rows? 750 columns is the max you can have per table.

IMHO I think a utility/pgm is best choice for this requirement

Kolusu

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Thanks Kolusu

But Number of rowes are limited 50 to 60 it is not going extend more then that, so that i am thinking to use SQL , Please guide me I am in the right Direction

Thanks
Cool

kolusu · Posted: Wed Aug 05, 2009 9:38 am Post subject:

coolguy,

You can follow the approach shown here given all your columns are numeric.

http://www.mvsforums.com/helpboards/viewtopic.php?t=5585&highlight=rows

At any rate , I think a program is best bet in this case.

Kolusu

coolguy · Beginner Joined: 01 Dec 2004 Posts: 82 Topics: 28

Thanks Kolusu!!! Thanks for Your Time and Help