Summary
This chapter discussed the process of creating static embedded SQL program modules. By embedding SQL statements into a programming language, you can manipulate the data contained in a DB2 UDB database. The programming modules containing the SQL statements must be converted from SQL statements to DB2 UDB library APIs. This step is known as the precompilation step, because it is always performed before the programming module is compiled and linked.
There are two types of database connections. The default database connection type is known as a Type 1 connect. This connection only allows a single database to be involved in a transaction or UOW. A Type 2 connection allows establishing connections to multiple databases within the same UOW. ...
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.
