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
- 14072 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mdv
DELETE FROM TABLE_NAME
WHERE RID(TABLE_NAME) = 7 ;
Works DB2 (V9 Onwards)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the physical storage length of the data types date, time, and timestamp?
How to create backup table in db2?
What is host variable?
What language is db2 written in?
Can you tell me how can you find out the # of rows updated after an update statement?
How and when does the db2 enforces the unique key?
What is clone table?
How to retrieve rows from a db2 table in embedded sql?
How do I start db2 in windows?
List out the buffer pools in db2
What is catalog database in db2?
Mention the location where the output received from explain statement is stored.
Define declaration generator (dclgen).
What is the result of open cursor statement?
What is table space in db2?
