Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15449 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 ibm db2 used for?
What is deadlock in db2?
How to find the maximum value in a column in the db2 database?
How can record locking be achieved in those DB2 versions which do not support it?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Highlight all the advantages that are attached to a package.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can you count the number of rows from a table tab?
How do I delete a column in db2?
List out the data types available.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is difference between isnull and coalesce?
What is the difference between using bind () and rebind () methods of naming class?
Which component is responsible for processing sql statements and selecting access paths?
What are the prerogatives?
