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: "Shanbhag, Mitesh (London)" <ShanbMit at exchange dot uk dot ml dot com>
Subject: RE: BCP
Date: Sep 13 2002 3:16PM

Thanks Michael.

Is this available in perl 5.004.04 ? i tried

DBSETLPACKET(4096);

and 

DBSETLPACKET($bcp, 4096);

in my script and it shouted 

Undefined subroutine &main::DBSETLPACKET called at mtm_cons_load line 115.
???

i have 

use Sybase::BCP;

eval { $bcp = new Sybase::BCP $username, $password, $server; };


Rgds,
Mitesh

-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: Friday, September 13, 2002 3:20 PM
To: SybPerl Discussion List
Subject: Re: BCP


On Fri, 2002-09-13 at 03:00, Shanbhag, Mitesh (London) wrote:
> Hi
> 
> I am using the bcp module ( Sybase::BCP ) - to populate a table from a
flat
> file. Is there a way I can specify a packet size here ? ( Perl ver
5.004.04
> )

Yes - simply call DBSETLPACKET($size) before you create the $bcp object.

Michael
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!