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 10, DB2 for i Version 7.1, and DB2 for Linux®, UNIX®, and Windows® Version 9.7.

Share:

Staff, IBM, Staff, IBM

This article is brought to you by IBM Staff.



13 June 2012 (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
  • 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 4

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

  • XML data type
  • Datetime constants
  • Extended indicator variables
  • Enhanced untyped parameter marker support
  • XMLCAST specification
  • New functions:
    • Aggregate Functions: XMLAGG
    • Datetime Scalar Functions: ADD_MONTHS, EXTRACT, LAST_DAY, MONTHS_BETWEEN, NEXT_DAY, ROUND_TIMESTAMP, and TRUNC_TIMESTAMP
    • Numeric Scalar Functions: BITAND, BITANDNOT, BITNOT, BITOR, BITXOR
    • String Scalar Functions: TRIM
    • XML Scalar Functions
    • MQSeries Functions
  • Enhanced TIMESTAMP_FORMAT and VARCHAR_FORMAT functions
  • CROSS JOIN
  • Retrieval of result sets in embedded SQL (ALLOCATE CURSOR and ASSOCIATE LOCATORS statements)
  • Expressions in a CALL statement
  • Distinct types in a temporary table
  • MERGE statement
  • CONCURRENT ACCESS RESOLUTION in PREPARE statement
  • SET host variable statement
  • Additional control statements in SQL functions

Download

Publication titlePDF SizeDownload Method
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
SQL Reference for Cross-Platform Development Version 3
(DB2 for: z/OS V9, iSeries V5R4, LUW V9)
9.4 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 10 for z/OS SQL Reference8.79 MBHTMLPDF
DB2 Version 9.1 for z/OS SQL Reference 8.11 MBHTMLPDF
DB2 for i SQL Reference Version 7.16.17 MBHTMLPDF
DB2 for i SQL Reference Version 6 Release 15.23 MBHTMLPDF
DB2 Universal Database for iSeries SQL Reference Version 5 Release 412.8 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
DB2 Version 9 SQL Reference (Vol. 1)8.11 MB (none) PDF
DB2 Version 9 SQL Reference (Vol. 2)7.45 MBHTML PDF

See the DB2 Product Family library page for more information.

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=06132012