Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


Limits


The limits specified for X/Open-95 are lower bounds. Compliant systems should support at least the specified number.

If a box is empty this means the standard does not specify a limit.

LIMIT
Mimer SQL
X/Open-95
CHARACTER string length
15000
254
Variable length CHARACTER string
15000
254
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
15
FLOAT precision in digits
45
47 bits
SMALLINT precision in digits
5
5
INTEGER precision in digits
10
10
BIGINT precision in digits
19

REAL precision in digits
7
21 bits
DOUBLE PRECISION precision in digits
16
47 bits
SQLCODE precision in digits
10
9
Fractional precision, in decimal digits, of TIME seconds component
9
6
Fractional precision, in decimal digits, of TIMESTAMP seconds component
9
6
Fractional precision, in decimal digits, of INTERVAL seconds component
9
6
Leading precision, in decimal digits, for INTERVAL data types
7-12
7
Fractional precision for INTERVAL data types that have a SECOND field
9
6
Number of columns in a table
252
100
Number of columns in an index
32
6
Number of tables referenced in a statement
unlimited 1
10
Number of cursors open simultaneously
unlimited 2
10
Number of columns a single update statement can update
unlimited a
20
Number of nested subqueries
15
9
Number of parameters for a function or procedure
unlimited b
N/A
SQL statement length in bytes
unlimited b
4000
Total length of a row, the sum of:
  • Two bytes for column identification
  • Lengths of all character fields
  • Precisions of all numeric fields
16000
2000
Identifier length
128
18
1
There is a limit on the total complexity of an SQL statement.
The specified X/Open limits can safely be handled by Mimer SQL.

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



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX