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

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

3 Answers
7035 Views
IBM, I also Faced
E-Mail Answers

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