IBM Support

SQL Reference for Cross-platform Development

News


Abstract

The SQL Reference for Cross-platform Development describes the common set of SQL language features that are supported across all platforms by the Db2 family products. Developers who build applications that must be portable across the IBM Db2 family of database products can use it to ensure the portability of the SQL in their applications.

Content

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
  • Built-in global variables
  • 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

Version 7 was published 11/2023.  Content details are available here.
Version 6 was published 10/2018.  Content details are available here.

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

Content format

Db2 13 for z/OS SQL Reference

HTML

PDF

Db2 12 for z/OS SQL Reference

HTML

PDF
Db2 for i SQL Reference Version 7.5 HTML PDF
Db2 for i SQL Reference Version 7.4 HTML PDF

Db2 for i SQL Reference Version 7.3

HTML

PDF
Db2 11.5 SQL Reference  (LUW) HTML PDF

Db2 11.1 SQL Reference  (LUW)

HTML

PDF

Db2 10.5 SQL Reference  (LUW)

HTML

PDF

(Volume 1)

PDF

(Volume 2)

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000CHeAAM","label":"IBM i Db2"}],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"ARM Category":[{"code":"a8m0z000000073SAAQ","label":"Compatibility"},{"code":"a8m0z000000074aAAA","label":"SQL"}],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m3p000000h9xfAAA","label":"Application Development"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

More support for:
IBM i

Component:
IBM i Db2

Software version:
All Versions

Operating system(s):
IBM i

Document number:
7053227

Modified date:
17 November 2023

UID

ibm17053227

Manage My Notification Subscriptions

Page Feedback