January 2005
Beginner to intermediate
928 pages
22h 14m
English
A package is a database object consisting of executable SQL, including the access path the DB2 optimizer will take to perform the SQL operation.
To explain how a package works, let's review Figure 7.26, which illustrates the preparation of a C application program with embedded SQL.
In the figure, the C program myprg.sqc contains embedded SQL. Issuing the precompile command (also known as the prep command) with the bindfile option generates two files, the myprg.bnd bind file containing only SQL information and the myprg.c file containing only C code.
The bind file will ...
Read now
Unlock full access