SQL Syntax Changes
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 |
|---|---|
|
You can use this date function. |
|
|
The CREATE TABLE and EXPLAIN statements have been extended. This information is only relevant for SAP MaxDB bridge functionality. |
|
|
The SQL clause INSERT ... SET... is no longer recommended to be used and might be removed from future versions. |
|
|
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. |
|
|
This SQL clause is no longer recommended to be used and might be removed from future versions. |
|
|
The SQL clause UPDATE ... VALUES ... is no longer recommended to be used and might be removed from future versions. |
|
|
An updatable join view table is no longer recommended to be used and might be removed from future versions. |
|
|
System table information has been changed, deleted, or added. |