|
|
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*
|
