In SQLCA , we have field named SQLERRD . In SQLERRD(3) , the no of rows su

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 / jagan

Answer Posted / jagan

In SQLCA , we have field named SQLERRD . In SQLERRD(3) , the
no of rows successful updated (or) inserted can be found .

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1109

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2907

What is precompiler in db2?

1075

What is the difference between using bind () and rebind () methods of naming class?

1452

What are the different types of base tables?

1159

What are bind parameters in db2?

1094

Explain the function done by data manager?

1329

How can you quickly find out the # of rows updated after an update statement?

1082

Can there be more than one cursor open for any program?

1223

What are packages in db2?

1071

Define db2 and its databases?

1110

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1138

What is with ur in db2?

1382

What is the difference between plan and package in db2?

1167

What are the rules for db2 programming?

1153