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

Correct.

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

Michael

> -----Original Message-----
> From: Michael Peppler [mailto:mpeppler@peppler.org] 
> 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.
mpeppler@peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html