The SQL Reference for Cross-Platform Development

Staff, IBM, Staff, SDI Corp.

This article is brought to you by IBM Staff.

Summary: 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.

Tag this!

Date: 09 Mar 2009 (Published 01 Jun 2002)
Level: Introductory
Activity: 7631 views

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.

Comments (Undergoing maintenance)

Trademarks | My developerWorks terms and conditions

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

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

author1-email=

author1-email-cc=