Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Answers were Sorted based on User's Feedback



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

Answer / ananth

Declare a cursor like this in the application program
exec sql
Declare empcur cursor with hold for
select empno,empname from emp
for update of empsal
fetch first 100 rows only
end-exec.
this query will retrieve the first 100 rows and the cursor
is positiond at the first row in the resultent table.

Is This Answer Correct ?    23 Yes 1 No

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

Answer / brooks

is there identity column in this table, for example, if
there is a column indexnum int(supposed start from 1), you
can use the Update Table Set XXX=XXX where indexnum < 101

Is This Answer Correct ?    0 Yes 6 No

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

Answer / rama krishna.

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

Is This Answer Correct ?    1 Yes 7 No

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

Answer / sireesha

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

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More DB2 Interview Questions

What is consistency token in db2?

0 Answers  


What information is held in SYSIBM.SYSCOPY?

1 Answers  


What can the Locate option of the Repair Utility accomplish?

2 Answers  


What is meant by isolation level?

3 Answers  


How can we retrieve the total number of records in RPG & CLLE?

0 Answers  


What are the rules for db2 programming?

0 Answers  


Mention the downsides of page level lock.

0 Answers  


wht is d/f between union and joins ?

2 Answers  


What is declare cursor?

0 Answers  


Once you create a view, where would information about the view be stored?

1 Answers  


What is an alias and how does it differ from a synonym?

3 Answers  


How do you retrieve the data from a nullable column?

2 Answers  


Categories