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

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1018

Mention the different locking levels that are available in db2.

1070

What is load utility in db2?

1130

Is db2 a mainframe?

968

Name the lockable units in DB2?

1073

What are the bind parameters ibm db2?

989

B37 abend during spufi?

1405

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11615

List some fields from sqlca?

1001

What are the full forms of spufi and dclgen and why are they used?

1023

What language is db2 written in?

980

How do I optimize a query in db2?

1038

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1030

What are db2 objects?

1000

can all users have the privilage to use the sql statement select * (dml)?

1102