Answer Posted / srinivas yadav
OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are db2 tables?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain in brief how does db2 determine what lock-size to use?
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 is lock escalation in db2?
what is the sqlcode -501
On which levels locks can be applied?
Define predicate?
How does cobol compile db2 program?
What is cobol db2?
What does db2 mean?
What is dbrm? When it will be created?
What is declare cursor?
What is buffer pool and list some of them?