|
Attribute
|
Name
|
Value
|
|
Maximum number of open cursors
|
OPEN_CURSORS
|
50
|
|
Maximum number of procedure arguments in an SQL CALL statement
|
TPE_MAX_PROC_ARGS
|
100
|
|
Maximum length of an SQL statement
|
TPE_MAX_SQLSTMTLEN
|
131000
|
|
Maximum length of a column in a table
|
TPE_MAX_FLDLEN
|
31983
|
|
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
|
5000
|
|
Maximum number of bytes that can be inserted in a large key entry
|
MAX_KEY_DATA_SIZE
|
1980
|
|
Maximum number of bytes that can be inserted in a small key entry
|
SMALL_KEY_DATA_SIZE
|
193
|
|
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: 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 table
|
|
Maximum number of foreign constraints in a table
|
SQL_MAXFRNCNSTRS
|
1000 total constraints per table
|
|
Maximum LOB length
|
SQL_MAXLOB
|
1 GB
|