Data Management Global

The SQL reference for cross-platform development

Authored by IBM Staff: Mark Anderson, Claire McFeely

The SQL Reference for Cross-Platform Development uses the familiar format of the product SQL Reference manuals and includes information on the following topics:

• Database concepts
• Built-in functions
• Built-in global variables
• Statements and queries
• SQL procedural language control statements
• Limits
• Programming in C, Java, COBOL, REXX, and external routines in general
• SQL return codes (SQLSTATEs)
• CCSIDs

New in Version 6

The addition of newer versions of the Db2 products means additional SQL features are now included.

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

Download

More resources

• A view of common features
• The SQL Reference for Cross-Platform Development documents a subset of common functionality that is available on each platform. For more information about a particular platform, be sure to consult the appropriate manuals, listed here: