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

What is load replace in db2?

1050

Explain the function done by data manager?

1338

What are the 2 sqlcodes that are returned?

1234

What is the use of predicate?

1087

What is the maximum size of varchar data type in db2?

1177

What is runstats utility in db2?

1070

What is the use of commit in db2?

1144

What is isolation level in db2?

1069

What is the role of union all and union

1188

What is a Foreign Key?

1140

Can we insert update delete in view?

1029

What is the maximum length of sqlca?

1613

Define data page.

1132

Which component is used to execute the sql statements?

1147

Which is faster delete or truncate?

1177