Professional Web Applications Themes

Complete online DB2 SQL reference? - IBM DB2

Troels Arvin <troelsarvin.dk> wrote: > Hello, > > I'm trying to find the complete online DB2 SQL reference for DB 2 UDB > Express. I've found > [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url] but it doesn't > mention a feature like "SELECT ... FETCH FIRST x ROWS ONLY", so I can't be > _the_ SQL reference for DB2 UDB. Where should I look? Have a look here: [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=c0008880.htm[/url] I don't know if there are any differences to DB2 Express, though. -- Knut Stolze Information Integration IBM Germany / University of Jena...

  1. #1

    Default Re: Complete online DB2 SQL reference?

    Troels Arvin <troelsarvin.dk> wrote:
    > Hello,
    >
    > I'm trying to find the complete online DB2 SQL reference for DB 2 UDB
    > Express. I've found
    > [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url] but it doesn't
    > mention a feature like "SELECT ... FETCH FIRST x ROWS ONLY", so I can't be
    > _the_ SQL reference for DB2 UDB. Where should I look?
    Have a look here:
    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=c0008880.htm[/url]

    I don't know if there are any differences to DB2 Express, though.

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

  2. #2

    Default Re: Complete online DB2 SQL reference?

    On Tue, 29 Jul 2003 11:03:26 +0200, Knut Stolze wrote:
    > Have a look here:
    > [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=c0008880.htm[/url]
    I still can't find "SELECT ... FETCH FIRST x ROWS ONLY" doented there.

    The only place where I've been able to find it is at
    [url]http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmstintsel.htm[/url]
    but it seems to be related to iSeries servers only(?). Weird.

    --
    Greetings from Troels Arvin, Copenhagen, Denmark

    Troels Arvin Guest

  3. #3

    Default Re: Complete online DB2 SQL reference?

    On Tue, 29 Jul 2003 13:04:00 +0200, Knut Stolze wrote:
    > Go to the "SELECT" statement, click on "subselect" and you will find the
    > FETCH FIRST clause there. Or, take this shortcut:
    > [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8doent.d2w/report?fn=r0000875.htm[/url]
    Thanks!

    - Added to [url]http://troels.arvin.dk/db/rdbms/[/url] (which I'll be happy to
    receive comments on, even though the page is not finished yet).

    --
    Greetings from Troels Arvin, Copenhagen, Denmark

    Troels Arvin Guest

  4. #4

    Default Re: Complete online DB2 SQL reference?

    Here's where it is

    [url]ftp://ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2s1e80.pdf[/url]

    and look under

    Chapter 4 : Queries
    ...
    Subselect
    ...
    fetch-first-clause

    Hope this helps. Do no know if udb express is different.
    cchattoraj Guest

  5. #5

    Default Re: Complete online DB2 SQL reference?

    It's in the SQL Reference Volume 1, Chapter 4, p. 579.

    Larry Edelstein

    Troels Arvin wrote:
    > On Tue, 29 Jul 2003 11:03:26 +0200, Knut Stolze wrote:
    >
    > > Have a look here:
    > > [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=c0008880.htm[/url]
    >
    > I still can't find "SELECT ... FETCH FIRST x ROWS ONLY" doented there.
    >
    > The only place where I've been able to find it is at
    > [url]http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmstintsel.htm[/url]
    > but it seems to be related to iSeries servers only(?). Weird.
    >
    > --
    > Greetings from Troels Arvin, Copenhagen, Denmark
    Larry Guest

  6. #6

    Default Complete online DB2 SQL reference?

    Hello,

    I'm trying to find the complete online DB2 SQL reference for DB 2 UDB
    Express. I've found
    [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url] but it doesn't
    mention a feature like "SELECT ... FETCH FIRST x ROWS ONLY", so I can't be
    _the_ SQL reference for DB2 UDB. Where should I look?

    --
    Greetings from Troels Arvin, Copenhagen, Denmark

    Troels Arvin Guest

  7. #7

    Default Re: Complete online DB2 SQL reference?

    Troels Arvin wrote:
    > Hello,
    >
    > I'm trying to find the complete online DB2 SQL reference for DB 2 UDB
    > Express. I've found
    > [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url] but it doesn't
    > mention a feature like "SELECT ... FETCH FIRST x ROWS ONLY", so I can't be
    > _the_ SQL reference for DB2 UDB. Where should I look?
    >
    Online at:

    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main[/url]


    See the "SQL Reference"

    You can also download the PDF copies.



    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    [url]http://www.newsfeeds.com[/url] - The #1 Newsgroup Service in the World!
    -----== Over 100,000 Newsgroups - 19 Different Servers! =-----
    Ian D Bjorhovde Guest

  8. #8

    Default Re: Complete online DB2 SQL reference?

    Troels Arvin <troelsarvin.dk> wrote:
    > Hello,
    >
    > I'm trying to find the complete online DB2 SQL reference for DB 2 UDB
    > Express. I've found
    > [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url] but it doesn't
    > mention a feature like "SELECT ... FETCH FIRST x ROWS ONLY", so I can't be
    > _the_ SQL reference for DB2 UDB. Where should I look?
    Actually, FETCH FIRST n ROWS ONLY is listed on the website you cited:

    [url]http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.doc/admin/r0000875.htm[/url]

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

Similar Threads

  1. Why is reference.vb hierarchally linked to reference.map?
    By Richard Myers in forum ASP.NET Web Services
    Replies: 1
    Last Post: May 6th, 04:37 PM
  2. Could Not Complete Your Request…
    By LRK@adobeforums.com in forum Adobe Photoshop Mac CS, CS2 & CS3
    Replies: 7
    Last Post: March 1st, 10:16 PM
  3. Could not complete
    By caraya1 webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 1
    Last Post: October 10th, 06:43 PM
  4. Replies: 0
    Last Post: September 7th, 06:53 PM
  5. Replies: 1
    Last Post: August 29th, 07:02 AM

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