Interested to Buy Any Domain ? << Click Here >> for more details...
How do you simulate the EXPLAIN of an embedded SQL
statement in SPUFI/QMF? Give an example with a host
variable in WHERE clause)
- 2 Answers
- 9052 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
EXPLAIN PLAN SET QUERYNO = 1
FOR SELECT EMPNO,WORKDEPT
FROM EMP E, DEPT D
WHERE E.EMPNO = D.EMPNO
AND E.EMPNO = ?
| Is This Answer Correct ? | 5 Yes | 5 No |
What is filter factor?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the maximum No of rows per page?
Who uses db2?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Where could you look if you had a question about whether a column has been defined as an index?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
what is the sqlcode -501
db2 restart logic ?
COBOL 
