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
- 9082 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 |
Update command
What is package in db2 mainframe?
pls explain the precompilation process of cobol-db2 pgm
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.
In terms of DB2 indexing, what is the root page?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is DCLGEN ?
What is check constraint in db2?
What is subquery ?
Outputs of explain are with matchcols = 0. What does this signify?
What is the difference between group by and order by?
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
COBOL 
