|
|
|
FairCom DB SQL has its own set of constraints:
Attribute |
Value |
|---|---|
Maximum number of procedure arguments in a FairCom DB SQL CALL statement |
50 |
Maximum length of a FairCom DB SQL statement |
32MB (prior to V10.2, the limit was 35,000 characters) |
Maximum length of a column: standard data types. |
65536 |
Maximum length of a column: VARBINARY and VARCHAR specifying the character set designated as NATIONAL CHARACTER |
32752 |
Maximum length of default value specification |
250 |
Maximum length for an identifier |
64 |
Maximum length of a connect string |
100 |
Maximum length for a user-name in a connect string |
64 |
Maximum length of an error message |
511 |
Maximum number of columns in a table |
2500 |
Maximum number of index components for a table, for all indexes on that table |
500 |
Maximum length of a CHECK constraint clause |
20,000 |
Maximum number of check constraints in a table |
4000 |
Maximum number of foreign constraints in a table |
4000 |
Maximum number of nesting levels in a FairCom DB SQL statement |
25 |
Maximum number of table references in a FairCom DB SQL statement |
250 |
Maximum size of input parameters for a FairCom DB SQL statement |
512 |
Maximum number of outer references in a FairCom DB SQL statement |
25 |
Maximum nesting level for view references |
25 |
Maximum recursion level for stored procedures |
10 |
