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.

4 Answers
15694 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / rama krishna.

UPDATE DB2 SET COL=VAR/EXPR WHERE ROWNUM<=1OO;

Is This Answer Correct ?

1 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sqlca?

1079

What is blu acceleration in db2?

1072

What is bind and rebind in db2?

1139

What are the contents of dclgen?

1112

What is a system catalog table in db2?

1186

Explain about cursor stability?

1052

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2535

What is buffer pool?

1108

If I have a view which is a join of two or more tables, can this view be updateable?

1139

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1439

How to execute stored procedure in db2 command editor?

1049

What is the clustering index in the db2 database?

1001

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1240

What is deadlock in db2?

1070

Give the name of some fields form sqlca.

1086