Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 15057 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / avi
When you are saying row no 3 , means your data is in sorted format and table having the primary key , so find the row no 3 primary key information and then delete it using the where clause with primary value .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you find out the # of rows updated after an update statement?
Mention the different locking levels that are available in db2.
What is page size in db2?
Explain correlated sub-queries.
What is concurrency?
Which isolation level provides maximum concurrency?
What is db2 and what is the use of db2 optimizer?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
Give the name of some fields form sqlca.
How do you concatenate the firstname and lastname from emp table to give a complete name?
What do you mean by cursor?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is query_cache_limit?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
