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
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 is copy pending status in db2?
What is db2 look?
What do you mean by cursor?
What is a db2 cursor?
Can we delete records from view?
define clustering index.
What is dbrm? What it contains?
If I have a view which is a join of two or more tables, can this view be updateable?
What is role in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the difference between using bind () and rebind () methods of naming class?
How to test SQL -911 error while developing COB-DB2 program
How would you find out the total number of rows in a db2 table?
Which component is responsible for db2 startup and shutdown?