Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

how to fetch multiple records without using cursor

Question Posted / suresh

Answers were Sorted based on User's Feedback



how to fetch multiple records without using cursor..

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

how to fetch multiple records without using cursor..

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

how to fetch multiple records without using cursor..

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

how to fetch multiple records without using cursor..

Answer / srini

It is possible in DB2 V8

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is a host variable?

3 Answers  

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

what is the difference between join and union?

4 Answers   IBM,

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

List out the buffer pools in db2

0 Answers  

wht displays the number of times a query modified ?

2 Answers   TCS,

what is consistency token

3 Answers  

What is cursor stability?

1 Answers  

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

What is db2 bind process?

0 Answers  

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

For more DB2 Interview Questions Click Here
Categories