query to just fetch first matching row and stop execution.
once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
- 2 Answers
- 4591 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / romeu viegas
Select ...
FROM ...
WHERE ...
FETCH FIRST 1 ROW ONLY
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / parthasarathi
select * from
(select * from emp a where rowid<(select max(rowid) from
emp b where a.empno=b.empno) x
where rownum=1
| Is This Answer Correct ? | 0 Yes | 1 No |
What do you do to keep the cursor from closing after a commit?
Define predicate?
Is it possible using max on a char column?
What is DYNSLT keyword? How do you perform selection using DYNSLT
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Name the various locking levels available?
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
When do you specify the isolation level?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
Q4. How will you get the count of record without using COUNT verb in query?
What is the role of the data page in the db2 database?
Mention some fields that are a part of sqlca.
COBOL 
