Re: I am looking for C library addon to PRO C to handle start and restart situations

Hi,

What kind of failures do you mean to restart after? Do you mean server is getting down? Or client side problems? Or network problems?

Does it mean that you want to restart from the first non- commited record of your flat file aftrer ANY (server/network/ client) failure?

Quite simple method for me is to remove each file from file system after complete load. Other thing you should do is to write in the database the record number in the flat file for each loaded record. In the case of failure find maximum loaded record number for the file in the database and restart from the next record.

But the most simple method is to load single file in one transaction with big rollback segment. Delete loaded file after commit and continue with next one.

Andrew Protasov

> We are creating programs in Pro C. We are looking to add restart capbabilites
> to our code, so that in case of a failure we can have program restart from
> last place.
>
> This is critical since we will be reading large flat files and loading them
> into oracle, in addition to selects from other sources.
Received on Sat Nov 14 1998 - 12:28:18 CST