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
- 10302 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 |
What is dynamic SQL?
Define data page.
What is a clustering index?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is query_cache_limit?
What are the 4 environments which can access DB2 ?
How to access db2 tables in mainframe?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Update command
What happens to the PLAN if index used by it is dropped?
When is the access path determined for dynamic SQL?
How do you find the maximum value in a column in db2?
COBOL 
