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