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
Difference between cobol and cobol-ii?
I have a File that has duplicate records. I need only those records that occur more than thrice.?
How do you define a variable of comp-1 and comp-2?
)If there are 10 steps in GDG, if I want to refer the step2 after step5 . what should I do?
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
What are the different rules for performing sort operation?
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
Explain the configuration section of a cobol program with examples of syntax.
which is Best IBM Mainframe Training and Placement Institute in Ameerpet Hyderabad
Write some characteristics of cobol as means of business language.
What is the compute verb? How is it used?
What rules are to be followed while using the corresponding options?
Write a program to explain size error.
What is link edit in cobol?
what is the use of outrecord?