Professional Web Applications Themes

Maximum Number of fields in table? - help... - IBM DB2

My apologies -- I searched all over the WWW and every DB2 book I have, but could find no information on the maximum number of fields possible in a DB2 7.2 Workgroup edition database table -- any help or ideas or links where I can get this information from will be extremely helpful. Thank you so very much!...

Sponsored Links
  1. #1

    Default Maximum Number of fields in table? - help...

    My apologies -- I searched all over the WWW and every DB2 book I have,
    but could find no information on the maximum number of fields possible
    in a DB2 7.2 Workgroup edition database table -- any help or ideas or
    links where I can get this information from will be extremely helpful.
    Thank you so very much!
    Sponsored Links
    sea Guest

  2. #2

    Default Re: Maximum Number of fields in table? - help...

    Look in the SQL Limits section of the SQL Reference Guide at

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

    under "Database Manager Limits".

    Larry Edelstein

    sea wrote:
     

    Larry Guest

  3. #3

    Default Re: Maximum Number of fields in table? - help...

    "sea" <com> wrote in message
    news:google.com... 

    They are called columns, not fields. This information is in the SQL
    Reference, Appendix A, SQL Limits.

    The maximum number of columns in a table depends on the page size:

    4K page size = 500 column limit
    8K, 16K or 32K page size = 1,012 column limit

    However, I would suggest you do some normalization if you get anywhere near
    these limits.


    Mark Guest

  4. #4

    Default Re: Maximum Number of fields in table? - help...

    Hi noname,

    stick with 750 which is the limit for z/OS.

    Regards Rolf
    Rolf Guest

Similar Threads

  1. Maximum number of simultaneous requests
    By blorg in forum Coldfusion Server Administration
    Replies: 6
    Last Post: May 31st, 07:25 PM
  2. Maximum number of sockets - FD_SETSIZE
    By A in forum PERL Modules
    Replies: 2
    Last Post: September 9th, 07:48 AM
  3. Maximum number of connections
    By cf_ConFusion in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: October 27th, 08:15 AM
  4. Maximum Number of Roles?
    By aconitus in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: July 28th, 03:32 PM
  5. Maximum number of characters in a field?
    By Bahaar in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: March 2nd, 09:15 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