SELECT * FROM TABLE WHERE COUNT(*) = 100;

I have 1000 rows in a db2 table.I want to update first 100
records,How do I do it?

Question Posted / sireesha

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

Answer Posted / sireesha

SELECT * FROM TABLE WHERE COUNT(*) = 100;

Is This Answer Correct ?

1 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is host variable?

1012

List some fields from sqlca?

1001

How to get the ddl of a table in db2?

1072

Where can you declare a cursor in a cobol-db2 program?

995

What is the difference between using bind () and rebind () methods of naming class?

1328

How do I import data from excel to db2?

1011

What is bind and rebind in db2?

1073

What is reorg and runstats in db2?

1143

Mention data types used in db2 ?

1106

What is dclgen in db2?

1082

What is check constraint in db2?

1012

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

1181

What is dbrm? What it contains? When it will be created?

992

What is runstats db2?

964

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?

2473