when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was
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 |
Post New Answer View All Answers
What is cursor stability in db2?
What is an instance database?
What is the maximum length of sqlca?
What is dpf in db2?
What are db2 objects?
What is a db2 schema?
What is the result of open cursor statement?
What are the contents of a dclmgen?
B37 abend during spufi?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
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 ?...
Outputs of explain are with matchcols = 0. What does this signify?
List down the data types in the db2 database.
Explain packages.
What is the use of runstats in db2?