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

select * from orders where odate between '2010-01-01'and
'2010-03-31' How do u fetch this into cursor?

Question Posted / rajesh_m13

Answers were Sorted based on User's Feedback



select * from orders where odate between '2010-01-01'and '2010-03-31' How do u ..

Answer / muneer

Declare orders_cur cursor
for
select * from orders where odate between '2010-01-01'and
'2010-03-31'.

Open orders_cur

fetch orders_cur....

Hi friends i think that will the procedure ...if any mistake
suggest me

Is This Answer Correct ?    4 Yes 0 No

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u ..

Answer / mahesh

don't use * in select statement while retrieving data from
database

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB2 Interview Questions

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

What else is there in the PLAN apart from the access path?

1 Answers  

How many clustering indexes can be defined for a table?

2 Answers  

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

what is the soft code for deadlock ?

2 Answers   Logica CMG,

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

What kind of database is db2?

0 Answers  

How to create backup table in db2?

0 Answers  

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

For more DB2 Interview Questions Click Here
Categories