MVSFORUMS.com

db2patient · Beginner Joined: 26 Jan 2006 Posts: 9 Topics: 5

Dear Sir,
We are in DB2 version 7. Is there any column limit on a table? How many columns at maximum a table can have?

We got to define a new table which will have 300 coumns.

Thank you.

kolusu · Posted: Wed Mar 14, 2007 2:06 pm Post subject:

db2patient,

For DB2 version 7 the total no: of columns in a table canNOT exceed 750

Check this link which lists all the LIMITS of DB2 version 7

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/A.0?DT=20010718164132

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

db2patient · Beginner Joined: 26 Jan 2006 Posts: 9 Topics: 5

Thank you very much sir. The link you gave me a good reference. You are great.