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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / brooks

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you do the explain of a dynamic sql statement?

1017

What is the picture clause of null indicator variable?

1083

What is the difference between cursor stability and repeatable read isolation levels?

1116

What is host variable?

1016

what is diffrence b/w file-aid tool and file-aid utility???

4812

What is a storage group (stogroup)?

1189

How do you stop a db2 database in linux?

960

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2007

What do you mean by commit and rollback?

977

What is phantom read in db2?

1074

What language is db2 written in?

983

What is buffer pool in the db2 database?

1047

What is the use of db2 optimizer?

1042

What is page size in db2?

906

Mention data types used in db2 ?

1109