Syntax Changes

Some syntax changes have been introduced in the transition from database version 7.5 to version 7.6. The most significant changes are listed below.

SQL Statement in Version 7.6

Change in Version 7.6 as Compared to Version 7.5

create_user_statement
alter_user_statement

The optional syntax element connect_mode is supported.

create_dbproc_statement
drop_dbproc_statement

Use of the keywords DBPROC and DBPROCEDURE is allowed.

create_function_statement
drop_function_statement

The optional syntax element PUBLIC and/or DETERMINISTIC is supported.

create_schema_statement
drop_schema_statement
rename_schema_statement

The use of schemas is supported.

The introduction of the schema concept brought syntax changes to several other SQL statements not individually listed here. For many of the object identifiers for which previously an owner was specified, now a schema is specified instead.

create_system_trigger_statement
drop_system_trigger_statement

The use of system triggers is supported.

create_table_statement

The optional syntax element NO FIXED LENGTH COLUMN is no longer supported.

grant_statement
revoke_statement

The syntax variant required for using schemas has been added in each case.

parameter_name

For specifying a parameter name, only the two variants :<identifier> and ? are supported; the other options have been eliminated.

sample_definition

If the sample size is defined as 0, then the tables from the UPDATE STATISTICS run are excluded.

inner_transaction_statement

The creation and use of inner transactions is supported.

savepoint_statement
release_savepoint_statement
rollback_to_statement

The setting and use of SQL savepoints is supported.

select_column

The syntax variants <result_column_name> = <expression>, <result_column_name> = ROWNO and <result_column_name> = STAMP are no longer supported.

set_statement

The syntax variant required for using schemas has been added.

top_spec

limit_clause

In a SELECT statement you can use the LIMIT clause or the TOP syntax element to limit the number of rows of a results table.

insert_statement
update_statement
delete_statement

The optional syntax elements NOWAIT and/or IGNORE TRIGGER are supported.

update_statistics

The syntax variant UPDATE STATISTICS AS PER SYSTEM TABLE is supported.

GET_OWNER(x,o)
GET_SCHEMA(x,o)

The string function GET_OWNER(x,o) has been renamed GET_SCHEMA(x,o).

named_query_expression
named_query_primary
named_query_spec
named_query_term

All SQL statements and syntax elements in this area are no longer supported.

open_cursor_statement

The SQL statement open_cursor_statement is no longer supported.

See also:

Syntax List