Interested to Buy Any Domain ? << Click Here >> for more details...
how to fetch multiple records without using cursor
- 14 Answers
- 40094 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 |
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
How to test SQL -911 error while developing COB-DB2 program
What is release/acquire in bind?
What does the REORG Utility do?
What is a synonym ?
what types of copies can be made with the COPY Utility ?
What is CHECK PENDING ?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is nvl in db2?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
What is the difference between cursor stability and repeatable read isolation levels?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
COBOL 
