DB2 Application Development Environment

Suppose you are writing an application program to access data in a DB2 database. When your program executes a SQL statement, the program needs to communicate with DB2. When DB2 finishes processing an SQL statement, DB2 sends back a return code, and your program should test the return code to examine the results of the operation.

To communicate with DB2, you need to choose one of these methods:

  • Static SQL

  • Dynamic SQL

  • Open database connectivity (ODBC)

  • JDBC application support

ODBC lets you access data through ODBC function calls in your application. You execute SQL statements by passing them to DB2 through an ODBC function call. ODBC eliminates the need for precompiling and binding your application and increases ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.