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
- 9048 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by between and in? Is between inclusive of specified range values?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How do you eliminate duplicate values in db2?
Is it possible using max on a char column?
What is db2 catalog database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What are the benefits of using the db2 database?
Can one database have multiple instances?
What is db2 instance?
What is rct?
Can we update view in db2?
What is a dbrm in db2?
When the like statement is used?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How is deadlock resolved?
