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 role of the data page in the db2 database?

0 Answers  

What is dbrm in db2 database?

0 Answers  

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

What is the physical storage length of timestamp data type?

0 Answers  

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

What is cobol db2?

0 Answers  

What is db2 purescale?

0 Answers  

What is the picture clause of null indicator variable?

0 Answers  

What is the use of runstats in db2?

0 Answers  

What is the maximum size of a char data type in db2?

0 Answers  

How to create db2 table in mainframe?

0 Answers  

For more DB2 Interview Questions Click Here
Categories