Michael Tiefenbacher, mip GmbH
IBM Gold Consultant & Champion
Searching for "pivot" in Google returns lots of EXCEL information, but data transformations can be done in Db2 with SQL as well (without moving your data into Excel and possibly back). SQL is a very powerful and mighty programming language and, in this session, it is all about transposing data--from row to column, column to row, denormalizing it into a single column, and reversing it again. Why that? Because we can. No, seriously, this is frequently needed for data preparation in Data Warehouse environments and is very often asked in forums like Stackoverflow, etc. And you even need it if you dig into the Db2 catalog. So let's look into it.