I am trying to display the rows data into columns. Is there any way to do this using SQL in DB2 UDB. I am using db2 udb v8.2.

Here is what I would like to display from:

Page# Fieldname Value
1 FirstName fabc
1 Lastname labc
2 Firstname fxyz
2 Lastnmae lxyz

To

Page# Firstname Lastname
1 fabc labc
2 fxyz lxyz

Any pointer?

Thanks.

search
db2 pivot\unpivot
on google :-)