how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
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 would you find out the total number of rows in a db2 table?
Why cursor is used in db2?
How does cobol compile db2 program?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is buffer pool in the db2 database?
What are the various isolation levels possible?
What is bind package and plan in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is an instance in db2?
What is the difference between spufi and qmf?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What are the contents of dclgen?
is it compulsory commitment control in journal?
What is dbrm? When it will be created?
When reorg is used?