Limits


LIMIT	Value
CHARACTER string length	15000
Variable length CHARACTER string	15000
NATIONAL CHARACTER string length	5000
Variable length NATIONAL CHARACTER string	5000
BINARY string length	15000
Variable BINARY string length	15000
DECIMAL precision in digits	45
FLOAT precision in digits	45
SMALLINT precision in digits	5
INTEGER precision in digits	10
BIGINT precision in digits	19
REAL precision in digits	7
DOUBLE PRECISION precision in digits	16
SQLCODE precision in digits	10
Fractional precision, in decimal digits, of TIME seconds component	9
Fractional precision, in decimal digits, of TIMESTAMP seconds component	9
Fractional precision, in decimal digits, of INTERVAL seconds component	9
Leading precision, in decimal digits, for INTERVAL data types	7-12
Fractional precision for INTERVAL data types that have a SECOND field	9
Number of columns in a table	252
Number of columns in an index	32
Number of tables referenced in a statement	unlimited 1
Number of cursors open simultaneously	unlimited 2
Number of columns a single update statement can update	unlimited a
Number of nested subqueries	15
Number of parameters for a function or procedure	unlimited b
SQL statement length in bytes	unlimited b
Total length of a row, the sum of: Two bytes for column identification Lengths of all character fields Precisions of all numeric fields	16000
Identifier length	128

1There is a limit on the total complexity of an SQL statement.

2The limit is only dependent on the amount of virtual memory available to the application.