In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
- 9 Answers
- 14069 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain dclgen.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Explain the function done by data manager?
How connect db2 database to datastage?
How to compare data between two tables in db2?
What is meant by dclgen?
What is a system catalog table in db2?
List down the data types in the db2 database.
what is a corelated subquerry?
What are the prerogatives?
What are the uses of db2 optimizer?
What are types of indexes?
How do you eliminate duplicate values in db2?
What is the syntax for FETCH in DB2 ?
What is database reorganization?
