UPDATE DB2 SET COL=VAR/EXPR WHERE ROWNUM<=1OO;

I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?

Question Posted / rama krishna.

4 Answers
15433 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / rama krishna.

UPDATE DB2 SET COL=VAR/EXPR WHERE ROWNUM<=1OO;

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is alias in db2?

981

What's The Error Code For Unique Index Voilation?

1153

How do you pull up a query which was previously saved in qmf?

1099

Mention the downsides of page level lock.

1112

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1180

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?

8994

What is the difference between db2 and oracle?

1068

What is coalesce in db2?

1055

What is the purpose of rollback and commit?

1086

How many databases are there?

989

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1005

Explain the contention situations caused by locks?

1013

What is sqlca’s maximum length?

1102

What is concurrency?

1150

What does db2 plan contain?

960