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
- 14574 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 db2 stogroup?
What are concurrency issues?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How do I optimize a query in db2?
Can there be more than one cursor open for any program?
What happens in bind step in a db2 program?
How to resolve deadlock issue
What is db2 optimizer?
What is rct?
What is cascading rollback?
Which are the db2 tools to protect integrity of the database?
How to find the maximum value in a column in the db2 database?
How do I copy a table in db2?
Are view updateable?
What is the physical storage length of time data type?
