Statements

---

JOIN Without SELECT

The way to write a join without starting with the SELECT keyword has been removed from the SQL standard (SQL-2003). Mimer SQL still supports that construction, but since it is deprecated it may be removed in a future release.

So instead of just writing

 table1 INNER JOIN table2 ON table1.col1 = table2.co2
 

specify the SELECT keyword, like:

 SELECT * FROM table1 INNER JOIN table2 ON table1.col1 = table2.co2

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.

Instead, specify CAST(NULL AS data-type).

Example

 SELECT c1, int_col FROM t1
 UNION
 SELECT c1, CAST(NULL AS integer) FROM t2;

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.

Win: On Windows, SQLCA is no longer available. Applications using SQLCA has to be modified to use SQLSTATE or SQLCODE instead.

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:

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se