Re: BCP Perl Questions (Revised)

Michael Peppler <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
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).

Michael

> 
> -Salahuddin Choudhary
> 
> 
-- 
Michael Peppler  -  [email protected]  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.