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 reorg?

1238

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

2262

Is db2 a mainframe?

1093

What is the purpose of using commit?

1150

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

1084

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1138

List out the buffer pools in db2

1128

Mention the definition of cobol in varchar field.

1315

Can we delete records from view?

1019

What is db2 purescale?

1052

Define buffer pool.

1098

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1242

What are the full forms of spufi and dclgen and why are they used?

1136

What is database reorganization?

1181

Explain what are the various isolation levels possible?

1094