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 does db2 plan contain?

1019

Explain various types of locks in db2?

1140

Explain db2.

1031

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2176

What are the bind parameters ibm db2?

1046

Explain packages.

1108

What is runstats db2?

1016

How can you find out the # of rows updated after an update statement?

1110

What is copy pending and check pending in db2?

996

How to take backup of table in db2?

1069

How to execute stored procedure in db2 command editor?

1047

What is the syntax for seeing the columns and data types of a table in the db2 database?

1164

What is syscat in db2?

998

How to fetch the last row from the table in SQL (db2)?

1651

How to create db2 table in mainframe?

1154