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...


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

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

where can we use index and subscript ? with example ?

3 Answers   CTS,


What is correlation names?

1 Answers  


What is the max length of sqlca?

0 Answers  


What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,


When do you specify the isolation level? How?

1 Answers  


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  


Differentiate between cs and rr isolation levels? Where do you specify them?

0 Answers  


What is ibm db2 connect?

0 Answers  


What is a page?

2 Answers  


what is datacom db?

2 Answers   CSC,


Which transaction use a command thread ?

1 Answers  


Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  


Categories