In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)

Answer Posted / giri reddy

use cursor to find out the primary key column value in that
row, then delete tha row using the primary key

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the physical storage length of timestamp data type?

853


What is database reorganization?

827


What is the clustering index in the db2 database?

745


Define db2 and its databases?

812


List out the data types available.

912


What are the various data types available in db2?

811


How do I delete a table in database?

779


Can we delete records from view?

746


Can we update view in db2?

762


What is the result of open cursor statement?

823


Can you use max on a char column?

826


What is difference between rollback and commit?

867


Is it possible to create an Instance in DB2 using DB2 Control Center ?

840


What are the contents of a dclmgen?

828


What is runstats utility in db2?

759