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.

Answer Posted / rama krishna.

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the picture clause of null indicator variable?

688

Can we insert update delete in view?

571

What is the difference between db2 and oracle?

673

What does a deadlock mean in DB2?

650

What is bufferpool in db2?

576

What is dbrm? What it contains? When it will be created?

591

Why do chiropractors use drop table?

658

How do I import data from excel to db2?

609

What is the use of commit in db2?

628

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

194

What is dbrm in db2 database?

586

What is db2 and what is the use of db2 optimizer?

649

Define check constraint.

642

What are the bind parameters ibm db2?

622

what is the responsibility of the construction superintendent

1660