Content

Version 6 of the SQL Reference for Cross-Platform Development includes SQL features common to the Db2 family of products.

The major new features covered in this book include:

• BINARY and VARBINARY data types
• aggregation-specification in an OLAP specification
• DISTINCT predicate
• Query enhancements:
  • OFFSET and LIMIT
  • period-specification
• New built-in functions:
  • Aggregate Functions: CORRELATION, COVARIANCE, COVARIANCE_SAMP, LISTAGG, MEDIAN, PERCENTILE_CONT, PERCENTILE_DISC, STDDEV_POP, STDDEV_SAMP, VARIANCE_POP, and VARIANCE_SAMP
  • Cast Scalar Functions: BINARY and VARBINARY
  • Datetime Scalar Functions: DAYOFMONTH
  • Miscellaneous Scalar Functions: WRAP
  • String Scalar Functions: LOCATE_IN_STRING and OVERLAY
• Miscellaneous Scalar function enhancements
• Procedures: XSR_ADDSCHEMADOC, XSR_COMPLETE, and XSR_REGISTER
• System-period temporal tables
• CURRENT TEMPORAL SYSTEM_TIME
• ALTER TABLE PERIOD clause
• ALTER TABLE GENERATED ROW BEGIN, ROW END, and TRANSACTION START ID
• CREATE TABLE PERIOD clause
• CREATE TABLE GENERATED ROW BEGIN, ROW END, and TRANSACTION START ID
• SET CURRENT TEMPORAL SYSTEM_TIME
• COMMENT on a sequence
• CREATE OR REPLACE TRIGGER
• CREATE TRIGGER SQL-control statements
• fetch-clause in Searched DELETE
• GRANT SCHEMA and REVOKE SCHEMA
• MERGE statement extensions
• Obfuscation of SQL functions, procedures, and triggers
• TRANSFER OWNERSHIP
• Declared constants in a compound-statement
• RETURN fullselect