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 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)

Answer Posted / pratap

delete from table where ROWNUM = 500;
As per IBM notes ROWNUM is support feature in DB2.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What rules are followed by the search verb.

1091


How to get the last record in vsam file in cluster? And how can you get the ksds file records into your cobol program?

1118


What is the usage of comp fields in cobol?

1169


How to use the same COBOL program in Batch and CICS on lines? explain with an example

2366


write a cobol logic. i have file that has 10 records .1 record go to first output file and second record goes to 2 output and etc

1216


How arrays can be defined in COBOL?

1192


i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com

2203


Why is it necessary that file needs to be opened in I-O mode for REWRITE?

1306


how do you reference the ksds vsam file formats from cobol programs

1160


how to convert the recors form vsam file to db2 table tru file aid

3245


Write a program that uses move corresponding.

1118


1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?

5790


what are decleratives in cobol?

2244


System Testing for Mainframe Developers What is System Testing? integration testing ? what's the procedure ..

2053


how do you reference the variable unblock file formats from cobol programs

1308