469,289 Members | 2,127 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,289 developers. It's quick & easy.

max number of colums - DB2 version 8.1

hello

can anyone tell me the max number of columns for a table in version
8.1?

thanks,
tom

Nov 12 '05 #1
2 2387
to*****@yahoo.com wrote:
hello

can anyone tell me the max number of columns for a table in version
8.1?


It depends on the page size of the table space that you use. Have a look at
table 12 here:
http://publib.boulder.ibm.com/infoce...n/r0001029.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2
to*****@yahoo.com wrote:
can anyone tell me the max number of columns for a table in version
8.1?


No idea on the limits for v8 but v7 had 500 columns on a table with 4k
page size and 1012 columns on tables with larger page size.

Bernd
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Joy | last post: by
1 post views Thread by basulasz | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.