we could replace the unknown values with a "?" eg: select nam

How do you do the EXPLAIN of a dynamic SQL statement?

Question Posted / swetha dasari

Answer Posted / swetha dasari

we could replace the unknown values with a "?"
eg:

select name

from database

where name = ?

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

When do you specify the isolation level?

972

Can we update view in db2?

945

what is a corelated subquerry?

1063

What is access path in db2?

924

What is dbrm? What it contains?

1110

What is the difference between plan and package in db2?

1037

Explain in brief how does db2 determine what lock-size to use?

959

How to execute stored procedures?

1063

Explain how can you do the explain of a dynamic sql statement?

1063

What is a cursor in programming?

1014

What is explain plan in db2?

942

What is a collection in db2?

983

What is blu acceleration in db2?

1014

Which are the db2 tools to protect integrity of the database?

1071

Explain the benefits you can get from mainframe connect?

911