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

when i am trying to update a table having 1000 rows. the
program abends.how we will come to know the last successful
updated row was. we are not using any commit operations

Question Posted / guest

Answers were Sorted based on User's Feedback



when i am trying to update a table having 1000 rows. the program abends.how we will come to know t..

Answer / sesha

If there is no commit is mentioned,processed records are
lost when an abnormal end occurs.Rows are inserted,
updated,deleted in a table, those changes will be
lost in case of abend.

Is This Answer Correct ?    7 Yes 0 No

when i am trying to update a table having 1000 rows. the program abends.how we will come to know t..

Answer / guest

check SQLERRD(3) from SQLCA copybook.

Is This Answer Correct ?    4 Yes 2 No

when i am trying to update a table having 1000 rows. the program abends.how we will come to know t..

Answer / girish kumar

if u want to update ur changes to the database, posible when the commit is executed or when the program successfully executed. none other any situation database will not update.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

What is ibm db2 used for?

0 Answers  

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

What are the isolation levels possible ?

3 Answers  

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

Explain the function of data manager.

0 Answers  

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

What is pagespace?

1 Answers  

For more DB2 Interview Questions Click Here
Categories