I'm new to this forum and I realy hope someone can help me.
My problem is that I need to create a file with data from a DB2 database.
The file should look like this
Code: Select all
ID ID2 Col1 Col2 Col3
11 1 12 2
12 3 15 1
12 4 9 12 4
16 2 20 16
And these values are stored in a db2-table like this
Code: Select all
ID ID2 Code Value
11 1 Col1 12
11 1 Col2 2
12 3 Col2 15
12 3 Col3 1
12 4 Col1 9
12 4 Col2 12
12 4 Col3 4
16 2 Col2 20
16 2 Col3 16
Hope you understand my problem.