-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|