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 / ajay

we need to know atleast 1 column data, else we can not delete data from table.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the latest version of ibm db2?

964


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2087


What is the maximum size of a char data type in db2?

771


Mention data types used in db2 ?

881


What is the advantage in De-normalizing tables in DB2?

936


On which levels locks can be applied?

856


What is scrollable cursor in db2?

799


What is meant by union and union all?

780


can we view the access paths created by dbrm ? how ? thx

6648


What is bind package and plan in db2?

801


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8307


What are union and union all?

727


How to create backup table in db2?

852


Why db2 is called db2?

770


How do I start db2 in windows?

795