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
- 15791 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
Explain package in db2 and its advantages?
How do I add a column to a table in db2?
What is db2 plan table?
Which component is responsible for db2 startup and shutdown?
What is cursor in dbms?
How to find the number of rows in a db2 table?
How to find the maximum value in a column in the db2 database?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Define data page.
What are packages in db2?
What is db2 instance?
Define check constraint.
What is the difference between cursor and select statement?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do I connect my db2 database to ibm?
