October 2004
Intermediate to advanced
688 pages
16h 35m
English
• Precompiling
• Binding
• Plan or package ownership
DB2 application programs often include embedded SQL statements. In order to compile these programs, the SQL statements must be converted into a language recognized by the compiler or the assembler. The DB2 precompiler or a host-language compiler needs to be used to
• Replace the SQL statements in the source programs with compilable code
• Create a database request module (DBRM), which communicates the SQL requests to DB2 during the bind process
After the source program has been precompiled, a load module is created and, possibly, one or more packages and an application plan created. Creating a load module involves compiling and link-editing the modified ...