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 precompiler in db2?

1014

What is db2 bind?

1082

How to take backup of table in db2?

1074

What is clone table?

1038

What does db2 mean?

1014

What is performance tuning db2?

1061

How do I optimize a query in db2?

1098

How to find schema of a table in db2?

1014

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

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

2846

What is the difference between nvl and coalesce?

1063

List out the data types available.

1152

How do we specify index to include or not during bind process.

2126

What is a cursor in programming?

1066

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270