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 bits

16

INTEGER precision in bits

32

BIGINT precision in bits

64

REAL precision in bits

24

DOUBLE PRECISION/FLOAT precision in bits

53

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 a

Number of cursors open simultaneously

unlimited b

Number of columns a single update statement can update

unlimited a

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/binary columns

Precisions of all numeric columns

32000

Identifier length

128

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

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