Raghuram Balakrishnan

 Profile Answers by Raghuram Balakrishnan 

• Jul 19th, 2007

 

During precompilation of a COBOL program with SQL queries, the SQL statements and COBOL codes are separated. The timestamp during precompilation helps in identifying the corresponding versions of these COBOL code and DBRM (SQL statements)...

The timestamp makes the latest version of the COBOL code use the corresponding DBRM for the program. 

During Bind process,
1. The SQL statements are checked gathering information from DB2 catalog for the tables accessed in the program.
2. The DBRM (Stripped out SQL statements) are converted into run-time instructions called a package.
3. The best path to access the corresponding package is identified. This path is called the Plan.