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
- 8972 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 explain in db2?
What is the purpose of the QUIESE Utility?
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?
what is SMP/E? and what are the major steps of it? thanks...
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
How many databases are there?
What does db2 mean?
what is the use of commit ? and what is the syntax?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
wht happens if we close cursor with cursor with hold option?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
COBOL 
