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
- 13451 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
How to find the number of rows in a db2 table?
When the like statement is used?
How do I delete a column in db2?
How to compare data between two tables in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is a cursor in programming?
Discuss about db2 bind?
what is the role of the cursor in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is query_cache_limit?
What is the default page size of buffer pools?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is ibm db2 database?
Which is faster delete or truncate?
How do I import data from excel to db2?
