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
- 10729 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 |
I use CS and update a page. Will the lock be released after I am done with that page?
What is nvl in db2?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
what is load and unload in db2
what is the difference between where clause and having clause
Is Cursor exicutable ?
what is SMP/E? and what are the major steps of it? thanks...
How does DB2 store NULL physically?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
How is the value function used?
What is usage pointer in cobol?
COBOL 
