Professional Web Applications Themes

Help with DB2 Syntax. - IBM DB2

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 ...

  1. #1

    Default 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.

    --
    Posted via [url]http://dbforums.com[/url]
    sharads Guest

  2. #2

    Default Re: Help with DB2 Syntax.

    sharads wrote on Thursday 03 July 2003 09:57:
    > 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
    Let's say your table is named "T", then you could use a query like this one:\

    SELECT t1.serv_hostname, t1.year, t1.month, t1.value AS "C:", t2.value AS "D:"
    FROM t AS t1 JOIN t AS t2 ON
    ( t1.serv_hostname = t2.serv_hostname AND
    t1.year = t2.year AND
    t1.month = t2.month )

    --
    Knut Stolze
    Information Integration
    IBM Germany / University of Jena
    Knut Stolze Guest

Similar Threads

  1. if/else tag syntax
    By negttid in forum Macromedia Flex General Discussion
    Replies: 8
    Last Post: March 20th, 02:15 AM
  2. Help with SYntax, Please!
    By Artspan in forum Macromedia ColdFusion
    Replies: 3
    Last Post: April 15th, 06:23 PM
  3. Syntax again - Help!
    By Geoff in forum Macromedia Flash Sitedesign
    Replies: 4
    Last Post: November 18th, 11:23 PM
  4. Need Help With Syntax!
    By Aaron Bertrand - MVP in forum ASP Database
    Replies: 10
    Last Post: August 7th, 03:44 PM
  5. Syntax
    By yma in forum ASP.NET General
    Replies: 1
    Last Post: July 3rd, 02:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139