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.

Example

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.