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

Actually, you don't need to delete this data, just move
foward the remaining data(from 8th to 100th), for example,
8th -> 7th
9th -> 8th
...
100th -> 99th

hope this is what you want

Is This Answer Correct ?    0 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the primary key a clustered index?

722


Outputs of explain are with matchcols = 0. What does this signify?

708


What are the contents of dclgen?

743


Is schema the same as database?

718


What is dpf in db2?

752






What is db2 connect?

691


What does db2 blu stand for?

759


What language is db2 written in?

675


How do I add a column to a table in db2?

711


What is a db2 tablespace?

688


What is reorg?

693


Is db2 free?

764


What is the maximum length of sqlca?

978


How to find primary key of a table in db2?

713


How to access db2 tables in mainframe?

696