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
  1. The limit per table for the sum of (the number of check constraints plus the number of foreign constraints) is 1000.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095