The dynamic SQL is prepared at run time and the access path is determined

When is the access path determined for dynamic SQL?

Question Posted / s

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

Please Help Members By Posting Answers For Below Questions

What is the syntax for creating a table in the db2 database?

1095

How is the value function used?

1145

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2206

Why do we need reorg in db2?

979

What is with ur in db2?

1296

How to find primary key of a table in db2?

1054

Explain various types of locks in db2?

1131

What are the bind parameters ibm db2?

1035

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1099

How can record locking be achieved in those DB2 versions which do not support it?

1068

When do you specify the isolation level?

1023

How is deadlock resolved?

1139

What is cursor with hold option in db2?

1060

is it compulsory commitment control in journal?

2470

What is the physical storage length of time data type?

1115