limitations

[Toralf Kirsten]

Hi,
please, can anybody tell me briefly
a) how many columns i) a table ii) a view may have
b) how many aliases can be used in a SQL statement

We use DB2 UDB 8.1 EE for Solaris.
Thanks a lot, Tori

[Mark A]

"Toralf Kirsten" <tkirsten@izbi.uni-leipzig.de> wrote in message
news:bfnvob$n5m$1@news.uni-leipzig.de...

> Hi,
> please, can anybody tell me briefly
> a) how many columns i) a table ii) a view may have
> b) how many aliases can be used in a SQL statement
>
> We use DB2 UDB 8.1 EE for Solaris.
> Thanks a lot, Tori
>

See Appendix A. SQL Limits, in the SQL Reference Volume 1.

You can downlaod DB2 manuals at:
[url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main[/url]
(Watch out for wraped lines.)

[Pierre Saint-Jacques]

The SQL Reference Guide is written espacially for this. You can get to
it online at
[url]http://publib.boulder.ibm.com/infocenter/db2help/index.jsp[/url]

The appendix has a whole list of limits and sizes.
HTH, Pierre.

Toralf Kirsten wrote:

> Hi,
> please, can anybody tell me briefly
> a) how many columns i) a table ii) a view may have
> b) how many aliases can be used in a SQL statement
>
> We use DB2 UDB 8.1 EE for Solaris.
> Thanks a lot, Tori
>