Miscellaneous SQL Enhancements
Miscellaneous additions to SQL are as follows:
• 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.
Last modified date: 01/30/2023