Whats the maximum no. of columns in a table

rajkan24 · New User Joined: 21 Feb 2005 Posts: 6 Location: India

hi ,

I am Rajesh. I have one doubt in db2.

1. Whats the maximum no. of columns in a table?

2. how to open a empty VSAM file?Is it possible to open?.

Rajesh.

khannay2k · New User Joined: 24 Feb 2005 Posts: 28 Location: Bangalore

Hi,
rajesh, rajesh here even,
1.max number of columns in a table is 224.
2.as for as i know, its not possible to open a empty VSAM file. will throw an error.

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi Rajesh(es),

It is possible to have an empty VSAM file.
When you open it up, it gives status code equivalent to end of file.

gskulkarni · New User Joined: 01 Mar 2006 Posts: 70

You can open an empty VSAM file, provided it is OPTIONAL and access Mode is DYNAMIC.

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Maximum number of columns allowed in a table is 750 as of Db2 v7.1.

Regards
Rags