|  | Level: Introductory Staff, IBM, Staff, IBM, Software Group
01 Jun 2002
Updated 09 Mar 2009 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 i Version 6.1, and DB2 for Linux®, UNIX®, and
Windows® Version 9.5.
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.1
The addition of newer versions of the DB2 products means the following great SQL features are now included:
- DECFLOAT data type
- Additional timestamp format
- Client special registers
- ROW CHANGE expressions
- New built-in functions
- order-by-clause and fetch-first-clause in a subselect
- SELECT FROM INSERT
- Full outer join
- ALTER FUNCTION
- IMPLICITLY HIDDEN columns
- row-change-timestamp columns
- RESTRICT on DROP of functions and procedures
- CURRENT DECFLOAT ROUNDING MODE special register and associated SET statement
- Other portability enhancements
Download
|
Publication title
|
PDF Size
|
Download Method
|
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
|
SQL Reference for Cross-Platform Development Version 2
(DB2 UDB for: z/OS V8, iSeries V5R3, LUW V8) | 8.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:
|
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 for i SQL Reference Version 6 Release 1 | 13.5 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 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 |
(none)
|
PDF
| | DB2 Version 9 SQL Reference (Vol. 2) | 7.45 MB |
HTML |
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 Product Family library page for more information.
About the author | | | This article is brought to you by IBM Staff. |
Rate this page
| |
DB2 and IBM are trademarks of IBM Corporation in the United States, other countries, or both. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. Windows is a trademarks of Microsoft Corporation in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Other company, product, or service names may be
trademarks or service marks of others. |
