When is the access path determined for dynamic SQL?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kamalakar
At runtime when the PREPARE statement is issued.
Is This Answer Correct ? | 3 Yes | 0 No |
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a collection in db2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
How to define the a field which accepts value till 99999.99 in db2
what is cursor stability?
What else is there in the PLAN apart from the access path?
What is reorg?
What is bind and rebind in db2?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
what is the use of commit ? and what is the syntax?
What's the difference between DB2 active log and archive log? Thanks a lot...
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .