My photo
Auckland, New Zealand
Smurf sized geeky person with a penchant for IT, gaming, music and books. Half of industrial duo 'the craze jones'. Loves data, learning new things, teaching new things and being enthusiastic.

Sunday, 5 December 2010

Further adventures on the dark side - DB2

DB2 is currently driving me insane.

All the normal things you can do in SQLServer seem to be missing, PIVOT for example, which in SQLServer allows you to.... wait for it.... cross tab your queries, weird that eh?  Though if they'd been really creative about it then it could have caused your data to do a rendition of swan lake before settling down into a cross-tab; that I would pay to see.  

Anyhoo, back to DB2 and the lack of PIVOT.  In order to achieve the same cross-tab result I have to jump into Excel, link my worksheet to a DB2 query, refresh the data in Excel, and then use Excel to perform the PIVOT.  How drawn out and painful is that?  Okay, whining over, back to the DB2 adventures.

No comments: