The SQL reference for cross-platform development

Great news for people who want to write portable applications! This reference makes it easy for you to develop applications using SQL that is portable across the DB2® database family, including DB2 for z/OS® Version 11, DB2 for i Version 7.2, and DB2 for Linux, UNIX, and Windows Version 10.5.

Share:

Staff, IBM, Staff, IBM

This article is brought to you by IBM Staff.



07 May 2015 (First published 01 June 2002)

Also available in Russian

Introduction

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

Resources

Learn

Discuss

  • Get involved in the developerWorks Community. Connect with other developerWorks users while you explore developer-driven blogs, forums, groups, and wikis.

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


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