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
Answer Posted / 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 |
Post New Answer View All Answers
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
How to fetch the last row from the table in SQL (db2)?
What is dbrm? What it contains?
What is page size in db2?
How to run db2 command in windows?
What is host variable?
What is the use of predicate?
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 ?...
Give the name of some fields form sqlca.
What are the prerogatives?
What is the purpose of rollback and commit?
What is cursor stability in db2?
What is iseries database?
Can we insert update delete in view?