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 use of db2 optimizer?

604


What are the contents of a dclmgen?

626


What is commit in db2?

591


What is nvl in db2?

624


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

1590






What is runstats db2?

576


What is alias in db2?

563


Can we update view in db2?

555


How can we retrieve the total number of records in RPG & CLLE?

190


What is the difference between dbm cfg and db cfg file in db2 ?

999


What does a deadlock mean in DB2?

647


What is check constraint in db2?

602


List out the buffer pools in db2

624


What action db2 takes when a program aborts in the middle of a transaction?

651


What is rct?

747