## 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:

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

Fractional precision, in decimal digits, of TIME seconds component

Fractional precision, in decimal digits, of TIMESTAMP seconds component

Fractional precision, in decimal digits, of INTERVAL seconds component

Leading precision, in decimal digits, for INTERVAL data types

Fractional precision for INTERVAL data types that have a SECOND field

Unlimited

^{1}Unlimited

^{2}Unlimited a

^{1}There is a limit on the total complexity of an SQL statement. Mimer SQL can easily meet the specified X/Open-95 limits.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |