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

7 No

Please Help Members By Posting Answers For Below Questions

What is ibm db2 used for?

1133

What is the difference between cursor and select statement?

1153

How many databases can be created inside an instance in db2 ?

1087

What is a storage group (stogroup)?

1287

Give the name of some fields form sqlca.

1146

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1154

Can there be more than one cursor open for any program?

1227

Comment whether the cursor is closed during commit or not.

1171

What is the meaning concurrency in the db2 database?

1170

How do I delete a column in db2?

1157

What is db2 purescale?

1055

What do you mean by commit and rollback?

1090

Name the lockable units in DB2?

1189

What parameters are used to control the free space in DB2?

1097

what is the role of the cursor in db2?

1115