Syntax Changes

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.