Interested to Buy Any Domain ? << Click Here >> for more details...
what is the input to PLAN?
what is the input to DBRM?
- 4 Answers
- 10599 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil reddy
DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.
PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nvl and coalesce?
What is the physical storage length of date data type?
what is utility for parm lib
What are host variables in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What are the different types of base tables?
What is the syntax for creating a table in the db2 database?
Explain how can you do the explain of a dynamic sql statement?
What is the advantage in De-normalizing tables in DB2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is a Foreign Key?
What is coalesce in db2?
What is meant by union and union all?
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 ?
