Actually, you don't need to delete this data, just move foward the r

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

Question Posted / sherman_li

9 Answers
15440 Views
IBM, I also Faced
E-Mail Answers

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

How can deadlocks be resolved?

889

Define predicate?

1062

What do you mean by storage group (stogroup)?

984

What is runstats db2?

963

What is bind and rebind in db2?

1070

Name the lockable units in DB2?

1072

Mention some fields that are a part of sqlca.

969

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2778

What is multi row fetch in db2?

982

Are view updateable?

975

What is netezza database?

957

Why do we bind in db2?

1137

What is schema in db2?

959

What is db2 bind process?

1172

What is the syntax for FETCH in DB2 ?

1136