PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

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).

Michael

> 
> -Salahuddin Choudhary
> 
> 
-- 
Michael Peppler  -  mpeppler@peppler.org  -  http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html