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

List some fields from sqlca?

613


What is dbrm in db2 database?

591


Is db2 a programming language?

607


How to view db2 table structure?

594


What is consistency token in db2?

644






Is db2 a mainframe database?

569


If I have a view which is a join of two or more tables, can this view be updateable?

694


What is database manager in db2?

551


Define declaration generator (dclgen).

667


What type of database is db2?

526


What are concurrency issues?

632


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

614


What is universal database?

619


What is runstats utility in db2?

569


What is the maximum number of columns in a db2 table?

725