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.

Answer / suma

we need to go for check point - restart logic.

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.

Answer / muneer

simply we have to use restart logic it will do the work

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.

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.

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.

Answer / madhukiranreddy

simply in program restart logic using we can retrive the records

Answer / kulbhushan

use with hold while using cursor

What is db2 optimizer?

0 Answers  

How can you count the number of rows from a table tab?

0 Answers  

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

What information is held in SYSIBM.SYSCOPY?

1 Answers  

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

What is lock escalation?

2 Answers  

What is dclgen (declaration generator)?

0 Answers  

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,