|  | Level: Introductory Staff, IBM, Staff, IBM
01 Jun 2002
Updated 28 Mar 2008 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 9, DB2 for
iSeries™
Version 5 Release 4, and DB2 for Linux, UNIX®, and
Windows®
Version 9.
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 3!
The addition of newer versions of the DB2 products means the following great SQL features are now included:
- BIGINT data type
- OLAP specifications
- New built-in functions
- INTERSECT and EXCEPT
- Recursive common table expressions
- Additional common features for ALTER COLUMN on ALTER TABLE
- Table partitions
- INSTEAD OF triggers
- SQL PL extensions including the FOR statement and support for nested ATOMIC compound statements
- Other portability enhancements
Download
|
Publication title
|
PDF Size
|
Download Method
|
SQL Reference for Cross-Platform Development Version 3
(DB2 for: z/OS V9, iSeries V5R4, LUW V9) | 9.4 MB | (none) |
PDF
|
SQL Reference for Cross-Platform Development Version 2
(DB2 UDB for: z/OS V8, iSeries V5R3, LUW V8) | 8.3 MB | (none) |
PDF
|
SQL Reference for Cross-Platform Development Version 1.1
(DB2 UDB for: z/OS V7, iSeries V5R2, LUW V8) | 3.1 MB | (none) |
PDF
|
More resources
- A view of common features.
- The developerWorks DB2 article
"DB2 UDB Family on Common Ground" (April 2002).
- 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:
|
Description
|
PDF size
|
Download Method
| | DB2 Universal Database for z/OS SQL Reference Version 9 | 20.1 MB |
HTML
|
PDF
| | DB2 Universal Database for z/OS SQL Reference Version 8 | 12 MB |
HTML
|
PDF
| | DB2 Universal Database for OS/390 and z/OS SQL Reference Version 7 | 4.6 MB |
HTML
|
PDF
| | DB2 Universal Database for iSeries SQL Reference Version 5 Release 4 | 12.8 MB |
HTML
|
PDF
| | DB2 Universal Database for iSeries SQL Reference Version 5 Release 3 | 10 MB |
HTML
|
PDF
| | DB2 Universal Database for iSeries SQL Reference Version 5 Release 2 | 4.4 MB |
HTML
|
PDF
| | DB2 Version 9.5 SQL Reference (Vol. 1) | 7.99 MB | (none) |
PDF
| | DB2 Version 9.5 SQL Reference (Vol. 2) | 7.85 MB |
HTML
|
PDF
| | DB2 Version 9 SQL Reference (Vol. 1) | 8.11 MB |
HTML
|
PDF
| | DB2 Version 9 SQL Reference (Vol. 2) | 7.45 MB | (none) |
PDF
| | DB2 Universal Database SQL Reference Version 8.2 (Vol. 1) | 2.4 MB | (none) |
PDF
| | DB2 Universal Database SQL Reference Version 8.2 (Vol. 2) | 2.4 MB |
HTML
|
PDF
| | DB2 Universal Database SQL Reference Version 8.1 (Vol. 1) | 3.1 MB | (none) |
PDF
| | DB2 Universal Database SQL Reference Version 8.1 (Vol. 2) | 2.4 MB | (none) |
PDF
|
See the DB2 Universal Database library page for more information.
About the author | | | This article is brought to you by IBM Staff. |
Rate this page
| |
|
