How do you do the EXPLAIN of a dynamic SQL statement?
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 |
Post New Answer View All Answers
What is the cobol picture clause of the db2 data types date, time, timestamp?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
How and when does the db2 enforces the unique key?
How does cobol compile db2 program?
How to retrieve rows from a db2 table in embedded sql?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Explain about open switch business continuity software?
How do you pull up a query which was previously saved in qmf?
What is meant by dclgen?
What is dbrm library?
What does db2 blu stand for?
What is deadlock in db2?
Can we delete records from view?
Explain package in db2 and its advantages?
What is null value in db2?