Answer Posted / tintu raveendran
It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is precompiler in db2?
Explain various types of locks in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What does db2 mean?
How does cobol compile db2 program?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are the rules for db2 programming?
How to find primary key of a table in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
Outputs of explain are with matchcols = 0. What does this signify?
What is the meaning concurrency in the db2 database?
What are the uses of db2 optimizer?
What is the use of with ur in db2?
What type of database is db2?
What is the use of db2?