How do you simulate the EXPLAIN of an embedded SQL
statement in SPUFI/QMF? Give an example with a host
variable in WHERE clause)
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 the difference between declaring the cursor in WS section and Procedure division?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Mention some fields that are a part of sqlca.
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Mention the definition of cobol in varchar field.
How do I delete a table in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a base table?
What is the picture clause of the null indicator variable?
How do I connect my db2 database to ibm?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are the functions in DB2?