DB2 programming samples

You can use programming samples to get started creating application programs that access data on DB2® for z/OS® subsystems.

The information that is collected in this section includes content from the following sources:

Content that is adapted from existing IBM® developerWorks® and other articles from around the web.
Samples that were previously delivered throughout in the existing DB2 programming information.
Examples that were previously supplied with DB2 in the DSN1010.SDSNSAMP library, but only recently included in their entirety in the documentation.

Note: This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. The sample programs are provided "AS IS", without warranty of any kind. IBM shall not be liable for any damages arising out of your use of the sample programs.

Programming interface information

This information is intended to help you to write programs that contain SQL statements. This information documents General-use Programming Interface and Associated Guidance Information provided by DB2 10 for z/OS.

Build a DB2 for z/OS mobile application using IBM MobileFirst Part 1
This is the first part of a three-part series about building an IBM DB2 for z/OS mobile application by using IBM MobileFirst™.
Example of a simple JDBC application
A simple JDBC application demonstrates the basic elements that JDBC applications need to include.
Example of a simple SQLJ application
A simple SQLJ application demonstrates the basic elements that JDBC applications need to include.
Example DB2 ODBC code
You can view example DB2 ODBC code for a sample verification program DSN8O3VP and for a client application APD29 that calls a stored procedure.
Tutorial: Working with XML data
pureXML lets you define table columns that store a single, well-formed XML document in each row. This tutorial demonstrates how to set up a DB2 database system to store XML data and how to perform basic operations with XML data.
Assembler, C, C++, COBOL, PL/I, and REXX programming examples
You can write DB2 programs in assembler language, C, C++, COBOL, Fortran, PL/I, or REXX. These programs can access a local or remote DB2 subsystem and can execute static or dynamic SQL statements.
Sample data and applications supplied with DB2 for z/OS
You can use sample applications that are included with DB2 for z/OS to learn about how to program applications that take advantage DB2 capabilities. DB2 also provides models for your own situations.