Skip to main content

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.

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 920.1 MB HTML PDF
DB2 Universal Database for z/OS SQL Reference Version 812 MB HTML PDF
DB2 for i SQL Reference Version 6 Release 113.5 MB HTML PDF
DB2 Universal Database for iSeries SQL Reference Version 5 Release 412.8 MB HTML PDF
DB2 Universal Database for iSeries SQL Reference Version 5 Release 310 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

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

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=

My developerWorks community

Tags

Help
Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).

My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

Use the search field to find all types of content in My developerWorks with that tag. Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere). My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).

Special offers