Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

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:

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:

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
Mimer SQL User's Manual TOC PREV NEXT INDEX