Interested to Buy Any Domain ? << Click Here >> for more details...
how to fetch multiple records without using cursor
- 14 Answers
- 38975 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 |
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
When is the access path determined for dynamic SQL?
What is the syntax for FETCH in DB2 ?
Can you use max on a char column?
what is load and unload in db2
how to resolve -811
What is the error code -803 ?
what is cursor stability?
What is referential integrity?
What are the contents of dclgen?
What is multi row fetch in db2?
Name the different types of Table spaces.
COBOL 
