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...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to resolve deadlock issue

19864


What is dbrm? When it will be created?

956


What is the role of union all and union

1069


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

990


How can we read records for specific member in CL? AND rpg?

644


How is deadlock resolved?

1081


What is db2 bind process?

1179


What is db2 and what is the use of db2 optimizer?

994


What is the information associated with sysibm.syslinks table?

1055


What are iseries servers?

1009


Name the lockable units in DB2?

1072


What is the function of logging in the db2 database?

1069


What is an instance in db2?

982


How do we specify index to include or not during bind process.

2070


List out the buffer pools in db2

1020