Configuring Db2 ODBC and running sample applications

Before you prepare and run ODBC applications, you need to install Db2 ODBC and run the sample applications.

Running the SMP/E jobs for Db2 ODBC installation
To install Db2 ODBC, you must edit and run SMP/E jobs.
The Db2 ODBC run time environment
Db2 ODBC support is implemented as an IBM® C/C++ Dynamic Load Library (DLL). All API calls are routed through the single ODBC driver that is loaded at run time into the application address space.
Db2 ODBC run time environment setup
The steps in setting up the Db2 ODBC run time environment must be performed once. These steps are performed as part of the installation process for Db2 for z/OS®.
Overview of preparing and executing a Db2 ODBC application
To prepare and execute a Db2 ODBC application, you need to follow certain steps and understand the Db2 ODBC components.
Db2 ODBC application requirements
To successfully build an ODBC application, you must ensure that the correct compile, prelink, and link-edit options are used. In particular, your application must generate the appropriate DLL linkage for the exported Db2 ODBC DLL functions.
Preparing and executing an ODBC application
You must compile, prelink, and link-edit an ODBC application before you can run it. Db2 ODBC provides sample programs to help you with program preparation.
How to define a subsystem to Db2 ODBC
You can define a Db2 subsystem in two ways. You can use MVSDEFAULTSSID, or you can use the default that is specified in the DSNHDECP load module.
Db2 ODBC initialization file
A set of optional keywords can be specified in a Db2 ODBC initialization file. An initialization file stores default values for various Db2 ODBC configuration options. Because the initialization file has EBCDIC text, you can use a file editor, such as the TSO editor, to edit it.
Database metadata stored procedures
When you install the ODBC drivers, you need to enable the metadata stored procedures.
Migrating to the Db2 13 ODBC driver
When you migrate the ODBC driver for Db2 for z/OS from the Db2 12 driver to the Db2 13 driver, you must set up the Db2 13 ODBC run time environment.
Migrating an ODBC 31-bit application to a 64-bit application
Consider migrating an application from 31-bit mode to 64-bit mode only if the application can take advantage of more than 2 GB of memory. Most applications run acceptably with the 31-bit addressing limitations.

Parent topic: Introduction to Db2 ODBC