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 difference between cursor and select statement?

0 Answers  

What is the size of a data page?

2 Answers   IBM,

What is coalesce in db2?

0 Answers  

Which are the db2 tools to protect integrity of the database?

0 Answers   IBM,

Which component is responsible for db2 startup and shutdown?

0 Answers  

What is a bind in db2?

0 Answers  

What is correlated subquery?

1 Answers  

define clustering index.

0 Answers  

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

Is ibm db2 free?

0 Answers  

what are the bind parameters?

5 Answers   IBM,

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

For more DB2 Interview Questions Click Here
Categories