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
How did the release of cobol/370 version 1.3 improve the performance of release 1.1?
What are INPUT PROCEDURE and OUTPUT PROCEDURE?
System Testing for Mainframe Developers What is System Testing? integration testing ? what's the procedure ..
What are the rules of the move verb?
can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there
What rules are to be followed while using the corresponding options?
What is Pic 9v99 Indicates in COBOL?
What is a SSRANGE and NOSSRANGE?
Why occurs cannot be used in 01 level in COBOL?
How do you differentiate between cobol and cobol-ii?
State the various causes of s0c1, s0c5 and s0c7.
how do you reference the rrds file formats from cobol programs
How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?
Explain what you understand by passing by value.
I have a File that has duplicate records. I need only those records that occur more than thrice.?