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
How can deadlocks be resolved?
What is the maximum No of rows per page?
What is rct?
How is a typical db2 batch pgm executed?
What is data manager?
Is the primary key a clustered index?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How to find primary key of a table in db2?
What is host variable in db2 cobol?
Explain the function of data manager.
What is the difference between db2 and oracle?
What r the comman abends in db2, jcl and cobol???????
What is difference between isnull and coalesce?
Explain how can you do the explain of a dynamic sql statement?
Mention the various locks that are available in db2.