Joined: 28 Jan 2004 Posts: 37 Location: Trivandrum
Here am trying to explain the DB2 - cobol process. The first stage is the precompilation step where the cobol program with the embedded SQL will be modified to form the modified source code and also the DBRM. The DBRM contains the sql statements. The timestamp is also alloted here, the information remains with both DBRM and the modified source code. In the modified source code the sql statemements will be replaced by call to DSNHLI statements with some 5 parameters. These are
1. The DBRM name.
2. SQL statement numbers.
3. The timestamp information.
4. Address info of SQLCA
5. Address info of host variables.
The DBRM undergoes the bind process and package is created. The package is not an executable so we make use of plan. The plan contains pointers to packages.
The modified source code is compiled , link edited to form load module. Then the timestamp is matched with the info in package. If mismatch is there we get timestamp mismatch error and rebind has to be done with proper DBRM.
here i have given just a rough idea abt the process. Pls do read some books for better clarity.
If we are changing the modified source program and we are not binding it what will happen? And in a case i m not changing the progm and again binding what will happen? Here in which case the timestand mismach will occur?