Background documentationSyntax Changes Locate this document in the navigation structure

 

Some syntax changes were made in the transition from database version 7.6 to version 7.7. They are listed below.

SQL syntax in Version 7.7

Change in Version 7.7 as Compared to Version 7.6

ALTER TABLE Statement

The options [NOT] CACHE and [NOT] NOCACHE were made available.

CREATE TABLE Statement

The options CACHE and NOCACHE were made available.

INSERT Statement

The SQL clause INSERT ... SET... is no longer recommended to be used and might be removed from future versions.

INTTORAW

The INTTORAW conversion function was made available.

Key Specification

UPDATE Statement

DELETE Statement

The SQL clause key specification (key_spec) is no longer recommended to be used in UPDATE or DELETE statements and might be removed in these SQL statements from future versions.

LIMIT Clause

You can specify a LIMIT clause in the SELECT statement.

LOB Column

The LONG [ASCII | BYTE | UNICODE | VARCHAR] data type is mapped to the data types CLOB [UNICODE] or BLOB.

OUTER JOIN Indicator

This SQL clause is no longer recommended to be used and might be removed from future versions.

Routine (routine)

The syntax for defining database procedures and functions was modified.

UPDATE Statement

The SQL clause UPDATE ... VALUES ... is no longer recommended to be used and might be removed from future versions.

Updateable Join View Table

An updateable join view table is no longer recommended to be used and might be removed from future versions.

Definitions of the System Tables

System table information has been changed, deleted, or added.