Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

System Limits

Maximum Values for FairCom DB SQL Attributes

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

TOCIndex