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

What are the rules for db2 programming?

1099

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11686

How can you count the number of rows from a table tab?

1093

Define declaration generator (dclgen).

1123

what is a corelated subquerry?

1125

What is the max length of sqlca?

1221

Explain how can you do the explain of a dynamic sql statement?

1130

How do you pull up a query which was previously saved in qmf?

1155

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1187

What are the various isolation levels possible?

1124

List down the data types in the db2 database.

1132

What is db2 look?

1031

What is the physical storage length of timestamp data type?

1102

What are union and union all?

985

What is bind package and plan in db2?

1058