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
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
| Publication title | PDF Size | Download Method | |
|---|---|---|---|
|
SQL Reference for Cross-Platform Development Version 4
(DB2 for: z/OS V10, i V7.1, LUW V9.7) | 3.9 MB | (none) | |
|
SQL Reference for Cross-Platform Development Version 3.1
(DB2 for: z/OS V9, iSeries V6.1, LUW V9.5) | 9.3 MB | (none) | |
|
SQL Reference for Cross-Platform Development Version 3
(DB2 for: z/OS V9, iSeries V5R4, LUW V9) | 9.4 MB | (none) | |
- 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 10 for z/OS SQL Reference | 8.79 MB | HTML | |
| DB2 Version 9.1 for z/OS SQL Reference | 8.11 MB | HTML | |
| DB2 for i SQL Reference Version 7.1 | 6.17 MB | HTML | |
| DB2 for i SQL Reference Version 6 Release 1 | 5.23 MB | HTML | |
| DB2 Universal Database for iSeries SQL Reference Version 5 Release 4 | 12.8 MB | HTML | |
| DB2 9.7 SQL Reference (Vol. 1) | 3.12 MB | (none) | |
| DB2 9.7 SQL Reference (Vol. 2) | 3.13 MB | HTML | |
| DB2 Version 9.5 SQL Reference (Vol. 1) | 7.99 MB | (none) | |
| DB2 Version 9.5 SQL Reference (Vol. 2) | 7.85 MB | HTML | |
| DB2 Version 9 SQL Reference (Vol. 1) | 8.11 MB | (none) | |
| DB2 Version 9 SQL Reference (Vol. 2) | 7.45 MB | HTML | |
See the DB2 Product Family library page for more information.




