When is the access path determined for dynamic SQL?
- 2 Answers
- 8387 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
The dynamic SQL is prepared at run time and the access path
is determined at execution time. Dynamic SQL changes from
one execution to another.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dbm cfg and db cfg file in db2 ?
Explain about rct.
What is load utility in db2?
What do you mean by storage group (stogroup)?
How many databases can be created inside an instance in db2 ?
What is copy pending and check pending in db2?
What is consistency token in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What does db2 stand for?
Explain about cursor stability?
Which are the db2 tools to protect integrity of the database?
How do I optimize a query in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What are concurrency issues?
