www.mimer.com/developer

SQL

---

Upright Database Technology's policy is to develop Mimer SQL, as far as possible, in accordance with the established standards. The following SQL standards are accepted as current:

• X/Open SQL 1995 (referred to here as X/Open-95)
• ISO/IEC 9075:1992 (referred to here as SQL-92)
• SQL/PSM (the section of the SQL-92 standard covering Persistent Stored Modules)
• ISO/IEC 9075:1999 (referred to here as SQL-99)

While any one standard defines a workable version of SQL, there are few if any vendors who supply database managers defined entirely within the bounds of a single standard. Mimer SQL combines many of the advantages of the different standards.

Mimer SQL 8 conforms to the following SQL standards:

• X/Open-95
• SQL-92 (entry and transitional levels)
• SQL/PSM

Triggers and Persistent Stored Modules are implemented according to the SQL-99 specification.

The primary goal of the X/Open-95 standard is to allow applications to be moved between database systems from different vendors that are X/Open compliant.

The following table lists the lower limits that compliant systems should support (if a box is empty the standard does not specify a limit):

Limit	Mimer SQL	X/Open-95
Character string length	15000	254
Variable length character string	15000	254
BINARY string length	15000	254
Variable BINARY string length	15000	254
DECIMAL precision in digits	45	15
FLOAT precision	45 digits	47 bits
SMALLINT precision in digits	5	5
INTEGER precision in digits	10	10
BIGINT precision in digits	19
REAL precision	7 digits	21 bits
DOUBLE PRECISION precision	15 digits	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 sub queries	15	9
SQL statement length in bytes	32767	4000
Total length of a row, the sum of: Two bytes for column identification Lengths of all character fields Precision of all numeric fields	16000	2000
Identifier length	128	18

1 There is a limit on the total complexity of an SQL statement. Mimer SQL can easily meet the specified X/Open-95 limits. 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