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 / kcs4u2004

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

Explain package in db2 and its advantages?

0 Answers  

What can the SET option of the Repair Utility accomplish?

1 Answers  

What is Skeleton cursor table (SKCT)?

2 Answers  

What is the syntax for creating a table in the db2 database?

0 Answers  

What Utility is used to migrate DB2 from one release to the next?

1 Answers  

Return code 100 means?

6 Answers   Cap Gemini,

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

What is read-only cursor?

1 Answers  

What is db2 instance?

0 Answers  

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

How many buffer pools are available in db2?

2 Answers  

For more DB2 Interview Questions Click Here
Categories