How to have a cross fields table in db2 sql?
I have a table with 3 field: code, week, value.
I want to have starting from this table a second table
with fields: code, week(n), week(n+1).... , week(m)
and in field week I want to put field value of the first table.
A cross fields table.
How to do it?