Contents


The SQL reference for cross-platform development

Comments

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 5

The addition of newer versions of the DB2 products means the following great SQL features are now included:

  • TIMESTAMP precision
  • New built-in functions:
    • Aggregate functions: ARRAY_AGG, GROUPING
    • Array scalar functions: CARDINALITY, MAX_CARDINALITY, TRIM_ARRAY
    • Miscellaneous scalar functions: LPAD, RPAD, VERIFY_GROUP_FOR_USER
    • Table functions: XMLTABLE
  • Miscellaneous scalar function enhancements
  • New built-in global variables
  • GROUP BY referencing super groups (CUBE & ROLLUP) and grouping sets
  • Row and column access controls: ALTER MASK, ALTER PERMISSION, CREATE MASK, and CREATE PERMISSION statements
  • ALTER TABLE DROP COLUMN RESTRICT
  • COMMIT ON RETURN and AUTONOMOUS procedures
  • CREATE FUNCTION (SQL scalar) statement allows more SQL-control statements in an SQL-routine-body
  • CREATE INDEX statement allows an index on expressions
  • Arrays: ARRAY element specification, array constructor, CREATE TYPE (Array) statement, compound-statement
  • Global variables: CREATE VARIABLE statement, GRANT and REVOKE (Variable privileges) statements
  • TRUNCATE statement
  • SET statement can specify multiple assignments

Download

Publication titlePDF SizeDownload method
SQL Reference for Cross-Platform Development Version 5
(DB2 for z/OS V11, i V7.2, LUW V10.5)
4.22 MB(none)PDF
SQL Reference for Cross-Platform Development Version 4
(DB2 for z/OS V10, i V7.1, LUW V9.7)
3.9 MB(none)PDF
SQL Reference for Cross-Platform Development Version 3.1
(DB2 for z/OS V9, iSeries V6.1, LUW V9.5)
9.3 MB(none)PDF

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:
DescriptionPDF sizeDownload method
DB2 11 for z/OS SQL Reference8.79 MBHTMLPDF
DB2 10 for z/OS SQL Reference8.79 MBHTMLPDF
DB2 for i SQL Reference Version 7.27.14 MBHTMLPDF
DB2 for i SQL Reference Version 7.16.17 MBHTMLPDF
DB2 for i SQL Reference Version 6 Release 15.23 MBHTMLPDF
DB2 10.5 SQL Reference (Vol. 1)4.07 MBHTMLPDF
DB2 10.5 SQL Reference (Vol. 2)4.19 MBHTMLPDF
DB2 9.7 SQL Reference (Vol. 1)3.12 MB(none)PDF
DB2 9.7 SQL Reference (Vol. 2)3.13 MBHTMLPDF
DB2 Version 9.5 SQL Reference (Vol. 1)7.99 MB(none)PDF
DB2 Version 9.5 SQL Reference (Vol. 2)7.85 MBHTMLPDF

Downloadable resources


Comments

Sign in or register to add and subscribe to comments.

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=90342
ArticleTitle=The SQL reference for cross-platform development
publish-date=05072015