October 2004
Intermediate to advanced
688 pages
16h 35m
English
• Table and view definitions
• Host variables and structures
• SQL execution validation
• Cursors
• Dynamic SQL
Suppose that you are writing an application program to access data in a DB2 database. When it executes an SQL statement, your program needs to communicate with DB2. When DB2 finishes processing an SQL statement, DB2 sends back a return code, which your program should test 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)
• Java Database Connectivity (JDBC) application support
Static and dynamic SQL statements can be embedded in application source programs. During the ...