• SET DATE_ALIAS [INGRESDATE | ANSIDATE] lets you control the date alias at the session level.

• SET NUMERIC_OVERFLOW provides another way to set error handling for numeric values that are outside the supported range of values.

• DROP...CASCADE drops all dependent objects when dropping a table, view, or index.

• DROP SCHEMA drops the specified schema and its collection of database objects.

• IS INGRESDATE predicate can be used to determine if a result can be assigned to a column of the given data type.

• LIKE WITH[OUT] DIACRITICAL indicates whether to ignore diacriticals during pattern matching.

• SIMILAR TO predicate can operate against an expanded set of character classes.

• CREATE INDEX...WITH STRUCTURE=RTREE no longer requires the RANGE option.

• HELP RULES ON TABLE displays all rules defined for the specified tables.

• COPY TABLE...INTO...WITH COMPRESSION creates LZH compressed data files.

• For details, see the SQL Reference Guide.