check for sqlca.sqlerrd[2] - as it indicates the number of rows processed

when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was

Question Posted / prachi

5 Answers
12260 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / prachi

check for sqlca.sqlerrd[2] -
as it indicates the number of rows processed before the
error occurred in a multirow INSERT, UPDATE, or DELETE
statement.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is db2 a mainframe?

1039

What r the comman abends in db2, jcl and cobol???????

2250

What is database alias db2?

1119

What is buffer pool in the db2 database?

1086

What is dbrm? What it contains?

1161

Which isolation level provides highest data integrity?

1114

What does runstats do in db2?

1099

How is deadlock resolved?

1144

What is the use of db2 optimizer?

1104

What is a bind card?

1212

What is a trigger in the db2 database?

1067

What is cascading rollback?

1206

What is the picture clause of null indicator variable?

1128

List down the data types in the db2 database.

1111

What are the various data types available in db2?

1087