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: "Sardar, Amit" <amit dot sardar at gs dot com>
Subject: RE: dbi and bulk insert
Date: Jul 30 2001 8:37PM

BCP style operations in Perl are useful for opening a connection and bcping
into temp (#) tables.
I believe this cannot be achieved with a combination of  perl and Sybase's
bcp utility.

Amit Sardar
Custody Technology
* ( 212 ) 855 9690

-----Original Message-----
From: Michael Peppler []
Sent: Monday, June 25, 2001 12:55 PM
To: SybPerl Discussion List
Subject: Re: dbi and bulk insert writes:
 > Do you know of any plans to augment DBI with a 'bulk insert' mechansism?
 > I would think this would fall under this module, no?

I've not heard of any plans for any bulk insert mechanism in DBI. I
could add something for the DBD::Sybase module specifically (i.e. in a
non-portable way), but I've found that doing BCP style operations in
perl is mostly a waste of time, and there are usually ways of
achieving the same results by combining perl and Sybase's bcp utility.

However, my opinion could be changed by a good argument :-)

Michael Peppler - Data Migrations Inc. - -
International Sybase User Group -
*Looking for new project to tackle starting 8/1/01*