Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: What's the best option for BCP
Date: Dec 17 2003 7:22PM

On Wed, 2003-12-17 at 11:14, Worenklein, David, GCM wrote:
> Of course, that makes error checking much more difficult.
> For instance, if Sybase deadlocks, bcp still returns success.  You have
> to scan the output of bcp to make sure it works.


But on the other hand I would probably not use bcp to load data to an
active table with indexes, etc (just because of such deadlock issues).

I guess it depends on the situation (as usual :-)


> -----Original Message-----
> From: Michael Peppler [] 
> Sent: Wednesday, December 17, 2003 11:17 AM
> To: Wechsler, Steven
> Cc: Sybperl (E-mail)
> Subject: Re: What's the best option for BCP
> On Tue, 2003-12-16 at 06:45, Wechsler, Steven wrote:
> > Michael (or anyone else who wants to answer)...
> > 
> > Previously I've always used Sybperl for BCPing into ASE servers;
> however,
> > it's been more than 3 years since I've last had to do it. Is Sybperl
> still
> > the best method for BCPing in inside Perl scripts on Unix and possibly
> NT?
> > Or has something new come along?
> sybperl's functionality in that respect hasn't changed much.
> However, I personally usually write the data to a temp file, and then
> use sybase's bcp command to bulk-copy the data, as that is usually the
> faster option.
> Michael
Michael Peppler                              Data Migrations, Inc.       
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions -