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 >> COBOL
  2. Suggest New Category

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

Question Posted / rafee.mfs

Answers were Sorted based on User's Feedback



In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data ..

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

In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data ..

Answer / suraj kumar pathak

SELECT * FROM (SELECT col1,col2,col3, rownumber() over() AS rn FROM tab1) as tr WHERE rn = 500;

Is This Answer Correct ?    4 Yes 5 No

In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data ..

Answer / venkata subbaiah

Delete from table where rowid=500;

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More COBOL Interview Questions

01 a pic 9(9v99) 01 b pic 9(9.99) wht will be the stored vales in both cases

6 Answers   Patni,

how to refer the data field?

0 Answers  

I have two questions here. 1. How to read a flat file in reverse order? 2. How to read a VSAM KSDS file in reverse order? In both the cases we donot know the total number of records.

1 Answers   L&T,

how we rectify soc4 and soc7 error in project(need real time answer)? please reply

3 Answers   HCL, Wipro,

If a file has 1000 records.. if i have to replace the first and last characters of the file with another character. how it can be done....

1 Answers   HCL,

How to code fscode 10 in cobol program? Where yoy code in your pgm?give ans for the question.

2 Answers   IBM,

What are the functions like c or c++ in cobol?

2 Answers  

How to Write the RESTART Logic Using COBOL?

4 Answers   GalaxE, L&T, Syntel, TCS,

should I use Go back in the main program ? Yes we can use Go back in main program as well.

2 Answers   Xansa,

What is Pic 9v99 Indicates in COBOL?

0 Answers   SwanSoft Technologies,

Describe the cobol database components?

0 Answers  

Can you call an OS VS COBOL pgm from a VS COBOL II pgm ?

3 Answers   Microsoft,

For more COBOL Interview Questions Click Here
Categories