convert the rows of data into columns in db2

adu_143 · #1 (**permalink**) 04-30-09, 02:51

Hi,

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 consolidate them to another table with multiple columns.

for example the table data from table A is as follows

column contract column value
1-A 25
1-A 50
1-A 75
1-B 15
1-B 20
...

then the table b should look like as follows -

col1 col2 col3 col4
1-A 25 50 75
1-B 15 20 -
.....

how do I do this in db2?

rahul_s80 · #2 (**permalink**) 04-30-09, 02:59

google :
db2 pivot unpivot table

tonkuma · #3 (**permalink**) 04-30-09, 03:02

Or search this forum with "recursive query".

adu_143 · #4 (**permalink**) 04-30-09, 05:25

Quote:

Originally Posted by rahul_s80

google :
db2 pivot unpivot table

Can you please help me with the desired query .. I looked for the example given on one of the site, but that has 3 cols and based on value of 2nd col he is picking up value of third.
In my case , I only have two cols as given ...