Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX