Progress
SQL-92
Guide and Reference
Progress SQL-92 System Limits
Table A–2 is a list of the maximum sizes for various attributes of the Progress SQL-92 database environment, and for elements of SQL-92 queries addressed to this environment. Attribute names may be seen in ESQL/C.
Table A–2: Progress SQL-92 System Limits Attribute Name Value Maximum number of procedure arguments in an SQL CALL statement TPE_MAX_PROC_ARGS 50 Maximum length of an SQL statement TPE_MAX_SQLSTMTLEN 131000 Maximum length of a column in a table TPE_MAX_FLDLEN 2000 Maximum length of default value specification TPE_MAX_DFLT_LEN 250 Maximum length of a connect string TPE_MAX_CONNLEN 100 Maximum length for a table name TPE_MAX_IDLEN 32 Maximum length for an area name TPE_MAX_AREA_NAME 32 Maximum length for a username in a connect string TPE_UNAME_LEN 32 Maximum length of an error message TPE_MAX_ERRLEN 256 Maximum number of columns in a table TPE_MAX_FIELDS 500 Maximum length of a CHECK constraint clause SQL_MAXCHKCL_SZ 240 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_MAXIPARAMS_SZ 512 Maximum number of outer references in an SQL statement SQL_MAX_OUTER_REF 25 Maximum nesting level for view references MAX_VIEW_LEVEL 25 Maximum number of check constraints in a table SQL_MAXCHKCNSTRS 1000 total constraints per table1 Maximum number of foreign constraints in a table SQL_MAXFRNCNSTRS 1000 total constraints per table1
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |