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

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

What are the various isolation levels possible?

0 Answers  

What is a base table?

2 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

What is the self-referencing constraint?

2 Answers  

What is a plan and package in db2?

0 Answers  

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

what is the name of the default db2 catalog database?

3 Answers   IBM,

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

What is collection in db2 bind?

0 Answers  

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

What is a DB2 access path?

1 Answers  

For more DB2 Interview Questions Click Here
Categories