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
- 9099 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 |
Where are plans stored?
what is + sign and -ve sign for sql code ?
What is sqlcode -922 ?
is it possible to get -811 error when you use cursors. why?
What is phantom read in db2?
What does the REORG Utility do?
WHAT IS MEANT BY COMMIT COMMAND?
wht are the restrictions for union ?
Which catalog table stores referential constraints?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What does sqlcabc has?
What is the role of the data page in the db2 database?
COBOL 
