Interested to Buy Any Domain ? << Click Here >> for more details...
When is the access path determined for dynamic SQL?
- 2 Answers
- 9110 Views
- I also Faced
- E-Mail Answers
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 |
What is the syntax of SELECT statement when embedded in a COBOL program?
What is dbrm?
How would the varchar column remarks defined?
what needs to be done if a table is in copy pending / check pending status?
What is meant by index cardinality?
What is the use of with ur in db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Q3. How will you fetch duplicate values from a DB2 table?
How to find last record before record through SQLRPGLE?
Which component is responsible for db2 startup and shutdown?
How do you find the maximum value in a column in db2?
How do I create a view in db2?
COBOL 
