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

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

2118

What is a trigger in the db2 database?

1143

How do you find the maximum value in a column in db2?

1154

What is the usage of open cursor command?

1146

What is release/acquire in bind?

1163

What is package in cobol db2?

1163

What is declare cursor?

1169

What is check constraint. Explain with example.

1163

How will you return the number of records in table?

989

Define predicate?

1204

What is the use of runstats in db2?

1179

What is meant by dclgen?

1173

What are union and union all?

1039

Is ibm db2 open source?

1132

Which command is used to remove all rows from a table?

1183