Re: More than 254 cols in table?

SQL/400 has 8,000. DB2/MVS has 750 (was 300 so you have to wonder what prompted them to raise the limit don't you)

Tony Rothwell (Tony_at_santen.demon.co.uk) wrote:
: In article: <3j4nbr$uru_at_locutus.rchland.ibm.com>
: kmill_at_hawkeyes.rchland.ibm.com (Kent Milligan) writes:
: >
: > In article <D4qJHA.FKM_at_freenet.carleton.ca>, ah513_at_FreeNet.Carleton.CA
 (Doug Harris) writes:
: > |> In a previous posting, Steve Edelstein (74160.645_at_CompuServe.COM)
 writes:
: > |>
: > |> At least Oracle is one of the better ones at 254.
: > |> --
: >
: >
: > I think the 254 limit pales in comparison to the 8000 column limit
: > supported by DB2/400. I know of a couple of our customers
: > that are well over 254 columns, but my mind is drawing a blank at
: > the business process that requires this at the moment.
: >
 

: Hi Kent
 

: Is this 8000 column per table support available in DB2 on all platforms,
: or just AS/400?
 

: -Tony.

--
Kirk Bradley
Oracle Corporation
Mainframe and Integration Technologies Group