Interested to Buy Any Domain ? << Click Here >> for more details...
how to fetch multiple records without using cursor
- 14 Answers
- 39631 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahi
I think it can be done with the help of arrays or Tables(in
cobol)
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / krishna reddy
we must know max no of records we want to fetch.
suppose max no record 50...
01 host-variable.
02 employee occurs 50 times.
05 eno pic 9(4).
05 ename pic A(20).
05 esal pic 9(5).
Declare cursor c1 for select eno,ename,esal from emp;
open c1.
fetch c1 into :host-variable.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anto
The question is to fetch multiple records...not multiple
row(s)..
So this is possible with single select query.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is bind in db2?
Mention the location where the output received from explain statement is stored.
wht are the restrictions for union ?
Which catalog tables contain authorization information?
What is the self-referencing constraint?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
What is the physical storage length of timestamp data type?
What is -904 sql code? How to resolve it?
What is ibm db2 client?
How do I delete a table in database?
How will fetch last 5 rows from table in db2
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
COBOL 
