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.

The following sample applications are provided:

DSN8O3VP, which is also available online in the DSN810.SDSNSAMP data set can be used to verify that your DB2 ODBC 3.0 installation is correct.
APD29, a client application that calls a DB2 ODBC stored procedure (SPD29), includes very fundamental processing of query result sets (a query cursor opened in a stored procedure and return to client for fetching). For completeness, the CREATE TABLE, data INSERTs and CREATE PROCEDURE definition is provided.