Building Embedded SQL Applications

Figure 9.1 illustrates the steps involved in building an embedded SQL application.

1.
Create source files that contain embedded SQL statements.
2.
Connect to a database, and then precompile each source file. The precompiler converts the SQL statements in each source file into DB2 UDB run-time API calls to the database manager. The precompiler also produces an access package in the database and optionally a bind file, if you specify that you want one created. Packages and bind files are discussed in the sections that follow.
3.
Compile the modified source files (and other files without SQL statements) using the host language compiler.
4.
Link the object files with the DB2 UDB and host language libraries to produce ...

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.