Chapter11.Binding an Application Program

Chapter 11. Binding an Application Program

  • 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 source code that is produced by the precompiler. Creating a package or an application plan, a process unique to DB2, involves binding one or more DBRMs. See Figure 11-1.

Figure 11-1. Program preparation

DB2 for z. OS Version 8 DBA Certification Guide
DB2 for z/OS Version 8 DBA Certification Guide
ISBN: 0131491202
EAN: 2147483647
Year: 2003
Pages: 175
Authors: Susan Lawson © 2008-2017.
If you may any questions please contact us: