Sorry about that, I didn't mean to send this since midway through writing
this I figured it out for myself.
--Curt
On Fri, 29 Jun 2001, Curt Russell Crandall wrote:
> I have a program that reads a file, and tries to process each line and
> insert the results into a database table. If the processing fails, the
> line is written to a reject file where it is corrected and reprocessed.
>
> In reject processing mode, I open the reject table, read a line, process
> it and then delete it from the table. Each line in the reject table has a
> numeric id as its primary key. If processing fails, the program reinserts
> the line back into the table under a different ID prior to
>
>