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 are db2 objects?

1046

Is db2 a database?

973

Why cursor is used in db2?

1036

How to find the number of rows in a db2 table?

1120

What is ibm db2 used for?

1081

What parameters are used to control the free space in DB2?

1056

Explain db2.

1037

What happens in bind step in a db2 program?

974

How to take backup of table in db2?

1075

How do I add a column to a table in db2?

1104

Is db2 a mainframe?

1043

Is db2 a programming language?

1049

What is null indicator in db2?

1113

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

1068

What is a storage group (stogroup)?

1246