Professional Web Applications Themes

limitations - IBM DB2

Hi, please, can anybody tell me briefly a) how many columns i) a table ii) a view may have b) how many aliases can be used in a SQL statement We use DB2 UDB 8.1 EE for Solaris. Thanks a lot, Tori...

  1. #1

    Default limitations

    Hi,
    please, can anybody tell me briefly
    a) how many columns i) a table ii) a view may have
    b) how many aliases can be used in a SQL statement

    We use DB2 UDB 8.1 EE for Solaris.
    Thanks a lot, Tori

    Toralf Kirsten Guest

  2. #2

    Default Re: limitations

    "Toralf Kirsten" <tkirstenizbi.uni-leipzig.de> wrote in message
    news:bfnvob$n5m$1news.uni-leipzig.de...
    > Hi,
    > please, can anybody tell me briefly
    > a) how many columns i) a table ii) a view may have
    > b) how many aliases can be used in a SQL statement
    >
    > We use DB2 UDB 8.1 EE for Solaris.
    > Thanks a lot, Tori
    >
    See Appendix A. SQL Limits, in the SQL Reference Volume 1.

    You can downlaod DB2 manuals at:
    [url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main[/url]
    (Watch out for wraped lines.)


    Mark A Guest

  3. #3

    Default Re: limitations

    The SQL Reference Guide is written espacially for this. You can get to
    it online at
    [url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url]

    The appendix has a whole list of limits and sizes.
    HTH, Pierre.

    Toralf Kirsten wrote:
    > Hi,
    > please, can anybody tell me briefly
    > a) how many columns i) a table ii) a view may have
    > b) how many aliases can be used in a SQL statement
    >
    > We use DB2 UDB 8.1 EE for Solaris.
    > Thanks a lot, Tori
    >
    Pierre Saint-Jacques Guest

Similar Threads

  1. Swatch Limitations?
    By Tricia_Schneberger@adobeforums.com in forum Adobe Illustrator Windows
    Replies: 4
    Last Post: June 9th, 04:41 PM
  2. Is there conversion limitations?
    By Kirk_Wassell@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: May 11th, 03:13 PM
  3. Limitations on x, y coordinates???
    By Amy G in forum Macromedia Flash
    Replies: 0
    Last Post: January 23rd, 10:18 PM
  4. MySQL limitations
    By Mike Mannakee in forum PHP Development
    Replies: 1
    Last Post: July 28th, 07:52 PM
  5. frontpage limitations
    By Daniel Temisanren in forum ASP Components
    Replies: 1
    Last Post: July 1st, 05:18 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