Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: BCP Perl Questions (Revised)
Date: Jul 17 2005 12:40PM
On Fri, 2005-07-15 at 18:30 -0400, Salahuddin Choudhary wrote:
> Hey guys,
> Just to make it easier, basically this is the issue:
> If I send 10,000+ entries, and one fails can I
> 1. Find out which row failed?
> 2. Remove the failed row and insert the rest of the batch
> 3. Automatically continue through the batch despite a failure
This should all be handled by the Sybase::BLK module.
Otherwise you have to recode it yourself to adapt it to your own use.
> Also, can I redirect BCP errors to a file when using program variables
> as input? thanks agian, sorry for the two emails.
I think you need to look at the error handlers (callbacks).
> -Salahuddin Choudhary
Michael Peppler - firstname.lastname@example.org - http://www.peppler.org/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html