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 can we retrieve the 100 records of the file ?

Question Posted / anjireddy vintha

Answer Posted / anjireddy vintha

select * from tabblename where rownum<101

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is cobol db2?

980

What is check constraint in db2?

1062

What are the various data types available in db2?

1072

How do I delete a table in database?

1004

What is ibm db2 client?

916

What are db2 tables?

1094

Mention the downsides of page level lock.

1146

Discuss about db2 bind?

1078

What is the physical storage length of time data type?

1104

What are concurrency issues?

1070

What r the comman abends in db2, jcl and cobol???????

2239

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2697

What is the difference between drop table and delete table?

1180

Explain the contention situations caused by locks?

1050

can we view the access paths created by dbrm ? how ? thx

7053