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.