When is the access path determined for dynamic SQL?

Answer Posted / kamalakar

At runtime when the PREPARE statement is issued.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cursor stability in db2?

805


What is the connection string to connect to the DB2 Database ?

612


What db2 400?

673


What is the difference between cursor and select statement?

609


How to view db2 table structure?

585






Is ibm db2 open source?

584


What is the cobol picture clause of the db2 data types date, time, timestamp?

611


What is the use of runstats in db2?

573


What is ibm db2 used for?

598


can we view the access paths created by dbrm ? how ? thx

6240


What is rebind in db2?

572


How do you eliminate duplicate values in db2?

679


What is load replace in db2?

560


What are union and union all?

537


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 ?

1816