Interested to Buy Any Domain ? << Click Here >> for more details...
when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was
- 5 Answers
- 12311 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinay srivastava
We can go in Abend Aid and look for the source listing where
we can find the last values stored in Host Variables where
the Job Abended.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / lenin
In cobol program, we can create one counter after each
successful update. So by checking the counter value we can
find out howmany rows are updated.
Please correct me if i am wrong..
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ramesh m
You can do the select query and in where condition, you
have to query for current timestamp for the particular row.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / 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 |
How do I connect my db2 database to ibm?
Which are the db2 tools to protect integrity of the database?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How would you find out the total number of rows in a db2 table?
Could anyone clearly explain the diference between sub query and correlated sub query?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Is ibm db2 free?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
can you use symbolic parameters in JOB?
What is a recovery log?
How to resolve -917 sql code in DB2?
What happens to a cursor after a commit?
COBOL 
