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
- 16053 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tim v
Are we talking the 7th row as sorted by key or 7th physical row? Since the rows aren't normally physically stored in order, I'd have to go with the latter.
Everyone seems to assume there is a PK on the table, but yet we don't know anything about the data... Again, this points to 7th physical row.
I'd go with the delete where RID(table) = 7 option since this assumes the 7th row inserted based on position and not value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the function of logging in the db2 database?
List out the buffer pools in db2
What are the full forms of spufi and dclgen and why are they used?
How can record locking be achieved in those DB2 versions which do not support it?
What is a plan and package in db2?
When do you specify the isolation level?
What is meant by union and union all?
What is the purpose of rollback and commit?
How do I connect my db2 database to ibm?
What is null in db2?
What is multi row fetch in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are packages in db2?
