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
What is db2 and what is the use of db2 optimizer?
Is the primary key a clustered index?
Explain dclgen.
What is blu acceleration in db2?
What types of tables are there in the db2 database?
What are the contents of a dclmgen?
What is syscat in db2?
Which command is used to remove all rows from a table?
What is a Foreign Key?
How would the varchar column remarks defined?
How do I add a column in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is db2 connect?
What is the difference between cursor and select statement?
Give a brief description of db2 isolation levels?