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 [mailto:email@example.com]
> 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;
> > it's been more than 3 years since I've last had to do it. Is Sybperl
> > the best method for BCPing in inside Perl scripts on Unix and possibly
> > 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 Peppler Data Migrations, Inc.
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html