Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose we are doing transaction in a table and abend happened in
between. Suppose i have completed the transaction upto X rows and
I want to start the transaction again where the abend happened. I
don't want to do the transaction from the first record. Then what
i have to do.
- 9 Answers
- 14344 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ignatius pradeep
We have a option called the BMC dedicated for this kind of
transaction errors. You can give a commit frequency too.
Example:
You have to insert 230 records into a table and your
transaction abends at 163 due to -803 or some error.
Now, If you define your BMC commit frequency to be 100, a
commit will be issued for every 100 records processed. So
in our example the first 100 records will be commited and a
checkpoint will be saved. When the transaction abends at
165 and you restart the job. The system will automatically
look at the last checkpoint and start processing from 101
record.
Let me know if i am wrong.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / debasis
Hi Kulbhushan
We cannot use with hold option for this. With hold is used so that the cursor will not be closed even after encountered with commit.
Anybody knows this answer. Please reply.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / muneer
simply we have to use restart logic it will do the work
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / ramakrishna javvaji
create a temporary table and write every row before
processing and delete it after it is processed.
In case of abend you will have the row at which it abended
in the temporary table. you can now drive the process based
on this info.
correct me if i am wrong.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sridhar
The way handle this is to mmaintain a seperate table in the
database with the columns like transaction id and key for
abend. Whenever abend happens the key and transaction type
has to be written to that table. The embeded sql where
clause has to be written in such way that it will allways
pick up the key from that table with >= option. If no key
is available then the where clause should be populated with
the key program has asked for.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / k.pratap
using flags.we correct that one.
first insert flag in u r table.
first write in u r cursor declaration with flag=0.
first take flag is 0.
after read the record.if record is successfully reading update flag is 1.ok.
if abend coming automatically rollback applied.
next the cursor going where the flag=0.it means it not successfully updated.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / madhukiranreddy
simply in program restart logic using we can retrive the records
| Is This Answer Correct ? | 0 Yes | 1 No |
How many sub queries can you combine together ?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What is the function of the Data Manager?
Are views updateable?
What is page size in db2?
What is a buffer in memory?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is the use of db2?
How can you count the number of rows from a table tab?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
When is the access path determined for dynamic SQL?
COBOL 
