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

In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)

Answer Posted / rajeev

In this scenario RRN will be useful.

DELETE FROM <FILENAME> F1 WHERE RRN(F1) = 7

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can deadlocks be resolved?

889


What is the maximum No of rows per page?

1010


What is rct?

1161


How is a typical db2 batch pgm executed?

1106


What is data manager?

993


Is the primary key a clustered index?

1077


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029


How to find primary key of a table in db2?

1001


What is host variable in db2 cobol?

1027


Explain the function of data manager.

988


What is the difference between db2 and oracle?

1067


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

2196


What is difference between isnull and coalesce?

1005


Explain how can you do the explain of a dynamic sql statement?

1062


Mention the various locks that are available in db2.

973