Appendix E: System Limits
Maximum Values
Table E–1 lists the maximum sizes for various attributes of the ODBC Server environment.
| Attribute | Name | Value |
|---|---|---|
| Maximum number of procedure arguments in an SQL CALL statement | TPE_ | 50 |
| Maximum length of an SQL statement | TPE_ | 35000 |
| Maximum length of a column: standard data types | TPE_MAX_FLDLEN | 2000 |
| Maximum length of a column: VARBINARY and VARCHAR specifying the character set designated as NATIONAL CHARACTER by the underlying storage system | TPE_ | 32752 |
| Maximum length of default value specification | TPE_ | 250 |
| Maximum length for an identifier ( | TPE_MAX_IDLEN | 32 |
| Maximum length of a connect string | TPE_MAX_CONNLEN | 100 |
| Maximum length for a user-name in a connect string | TPE_UNAME_LEN | 32 |
| Maximum number of database connections | TPE_MAX_NO_CONN | 10 |
| Maximum length of an error message | TPE_MAX_ERRLEN | 256 |
| Maximum number of columns in a table | TPE_MAX_FIELDS | 500 |
| Maximum number of index components for a table, for all indexes on that table | SQL_MAXIDXENTRIES | 100 |
| Maximum length of a CHECK constraint clause | SQL_MAXCHKCL_SZ | 240 |
| Maximum number of check constraints in a table | SQL_MAXCHKCNSTRS | 1000 |
| Maximum number of foreign constraints in a table | SQL_MAXFRNCNSTRS | 1000 |
| Maximum number of nesting levels in an SQL statement | SQL_MAXLEVELS | 25 |
| Maximum number of table references in an SQL statement: Microsoft Windows | SQL_MAXTBLREF | 50 |
| Maximum number of table references in an SQL statement: other platforms | SQL_MAXTBLREF | 250 |
| Maximum size of input parameters for an SQL statement | SQL_ | 512 |
| Maximum number of outer references in an SQL statement | SQL_ | 25 |
| Maximum nesting level for view references | MAX_VIEW_LEVEL | 25 |