Summary

A lot was covered in this chapter and still there is so much more that could have been discussed. Early in the chapter, we discussed the basic program flow for a CLI/ODBC application and defined it as consisting of three phases: initialization, transaction, and termination. The initialization phase consists of allocating various handles and resources needed to establish a connection to the database and to make that connection. The termination phase did quite the opposite and is the process needed to disconnect from the database and free all of the allocated resources needed to access the database.

The transaction phase is the largest and most complex of these phases. In its basic form it is the phase whereby an SQL statement is executed ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition 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.