kashi2005

 Profile Answers by kashi2005 

• Aug 20th, 2008

 

It checks the SQL query and checks the permissions for users

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• Aug 25th, 2008

 

Pre-compilation---> Pre compiler check's the program for any embedded sql statements if found than separates them into a DBRM and an object module is formed for the host language to be compiled by the compiler.....On the otherhand the DBRM that is formed is either binded into a package or a plan to form an effective application plan....Now when the program that had embedded sql-statements is finally run than,for each of the sql statements a call is made to the corresponding table using the application plan which had the optimised accesss logic.Remember in programs with embeded sql-statements at run-time a thread is created between the program and the table it tries to access!

yuvaevergreen

 Profile Answers by yuvaevergreen 

• Apr 11th, 2010

 

Precompilation:
Separates out the SQL statements in the COBOL program and creates the DBRM.
BIND:
Creates the executable format of DBRMs.

naga1126

 Profile Answers by naga1126 

• Jun 16th, 2010

 

Bind process is mainly for two processes:
1. To syntax check the Query (To see the Columns and tables referred are actually present etc. )
2. To find the efficient access path.

Result of Bind is an Executable form of the DBRM.