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: "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
* Amit.Sardar@gs.com



-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: Monday, June 25, 2001 12:55 PM
To: SybPerl Discussion List
Subject: Re: dbi and bulk insert


Stephen.Sprague@morganstanley.com 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
-- 
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
*Looking for new project to tackle starting 8/1/01*