Background documentationSQL Syntax Changes Locate this document in the navigation structure

 

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

SQL Syntax in Version 7.8

Change in Version 7.8 as Compared to Older Versions

ADD_MONTHS(t,a)

You can use this date function.

INSERT Statement

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

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.

OUTER JOIN Indicator

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

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 updatable 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.