How do you simulate the EXPLAIN of an embedded SQL
statement in SPUFI/QMF? Give an example with a host
variable in WHERE clause)
Answer Posted / raj
Not getting the ans.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How can you quickly find out the # of rows updated after an update statement?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is runstats db2?
What is check constraint in db2?
What is null in db2?
What is coalesce in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the difference between drop table and delete table?
What is an instance database?
What is the function of logging in the db2 database?
What is declare cursor?
What is image copy in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What's The Error Code For Unique Index Voilation?