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
- 13490 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sherman_li
Actually, you don't need to delete this data, just move
foward the remaining data(from 8th to 100th), for example,
8th -> 7th
9th -> 8th
...
100th -> 99th
hope this is what you want
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
What is the difference between db2 and oracle?
What is the use of commit in db2?
How can you classify the locks in db2?
How to check sequence on a table in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do I start db2 in windows?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What are union and union all?
How to take backup of table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is meant by union and union all?
How to rename a table in DB2 ?
What is the physical storage length of the data types date, time, and timestamp?
Define sqlca.
