Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Statements


CONNECT

The syntax of the standard CONNECT statement differs from that in earlier versions of Mimer SQL. The previous form is still supported for backward compatibility.

Backward compatibility syntax:



Note: The CONNECT statement and the standard-compliant CONNECT TO statement have different default modes for SET TRANSACTION START. CONNECT uses SET TRANSACTION START EXPLICIT, while CONNECT TO uses SET TRANSACTION START IMPLICIT.

ORDER BY Ordinal Position

Using an integer value to represent the ordinal position in an ORDER BY specification is deprecated due to changes in the SQL standards.

SELECT NULL

The use of the keyword NULL in a select list is still supported for backward compatibility but should be regarded as a deprecated feature in Mimer SQL.

INCLUDE SQLCA

Prior to version 7.2 of Mimer SQL, an INCLUDE SQLCA statement was required in an embedded SQL program, to include the declaration of the SQL communication area.

The INCLUDE SQLCA statement is now no longer required. Instead applications can use the SQLSTATE variable and the GET DIAGNOSTICS statement to get the information that was contained in SQLCA in the earlier Mimer SQL versions.

See Return Status and Conditions for a description of SQLSTATE. For compatibility reasons the use of SQLCA is still supported.

SET TRANSACTION

Following the introduction of the SET TRANSACTION READ and SET TRANSACTION ISOLATION LEVEL options, the SET TRANSACTION CHANGES options no longer apply.

The following options are supported for backward compatibility only:



CREATE IDENT

The keyword USING is now used when specifying the password-string for the ident being created. The use of IDENTIFIED BY is deprecated.

The following syntax is supported for backward compatibility only:



ALTER IDENT

The keyword USING is now used when specifying the password-string for the ident being altered. The use of IDENTIFIED BY is deprecated.

The following syntax is supported for backward compatibility only:



ENTER

The keyword USING is now used when specifying the password for the program ident being entered. The use of IDENTIFIED BY is deprecated.

The following syntax is supported for backward compatibility only:



SELECT

The option of specifying a non-zero integer in the ORDER BY clause of a SELECT statement which represents the ordinal number of a column in the result table of a SELECT statement is a deprecated feature.

The deprecated syntax is still supported for backward compatibility. Its continued use, however, is discouraged because a future version of Mimer SQL will support a syntax allowing the specification of an expression in the same place as the integer, which will have incompatible semantics.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX