Help with DB2 Syntax

Hi Everyone,

Recently our comany upgraded their applications from
MS ACCESS 2000 to DB2 version 7.2 UDB. I'm not as
skilled in DB2 with the syntax.

I had a few sql queries in Accesss that i just cannot
convert to DB2, if there is anyone who can help please
let me know.

I can get the query to output the results like this:

serv_hostname year month disk_drive value
-------------- ---- ----- ------------ ---------
megaweb1 2003 Mar C: 86.073
megaweb1 2003 Mar D: 88.603
megaweb1 2003 Apr C: 85.958
megaweb1 2003 Apr D: 84.425
megaweb1 2003 May C: 85.844
megaweb1 2003 May D: 82.293
megaweb1 2003 Jun C: 85.292
megaweb1 2003 Jun D: 75.189

But I need in in the format below: (this is done in access
using the TRANSFORM and PIVOT statements.)

serv_hostname year month C: D:
-------------- ---- ----- ------ ------
megaweb1 2003 Mar 86.073 88.603
megaweb1 2003 Apr 85.958 84.425
megaweb1 2003 May 85.844 82.293
megaweb1 2003 Jun 85.292 75.189

Any help will be greatly appreciated.

Thanks,
Sharad.

Lets name first query (columns serv_hostname, year, month, disk_drive, value) as QRY.

SELECT serv_hostname, year, month, SUM(CASE WHEN disk_drive='c:' THEN value ELSE 0 END) AS C, SUM(CASE WHEN disk_drive='D:' THEN value ELSE 0 END) AS D FROM QRY GROUP BY serv_hostname, year, month

(Sample is actual for DB2/400, may work on PC-version too.)