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: "Scott Zetlan" <scottzetlan at aol dot com>
Subject: RE: BCP
Date: Sep 13 2002 4:09PM

Try

use Sybase::BCP;
$bcp = new Sybase::BCP $user, $pass, $server; #etc.
$bcp->DBSETLPACKET (4096);

Just calling DBSETLPACKET() by itself doesn't tell perl in which package to
find the sub, so it checks for main::DBSETLPACKET (which doesn't exist,
because it's not exported to the main:: namespace by default).

Scott

> -----Original Message-----
> From: owner-SYBPERL-L@list.cren.net
> [mailto:owner-SYBPERL-L@list.cren.net]On Behalf Of psinnottie@aol.com
> Sent: Friday, September 13, 2002 11:53 AM
> To: SybPerl Discussion List
> Subject: Re: BCP
>
>
> On Fri, Sep 13, 2002 at 04:16:27PM +0100,
> ShanbMit@exchange.uk.ml.com wrote:
> > 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.
> > ???
> >
>
> Hi,
>     DBSETLPACKET doesn't seem to be exported by Sybase::DBlib or by
> Sybase::BCP so it is not available to your script. If you add
> DBSETLPACKET to @EXPORT in both Sybase/DBlib.pm and Sybase/BCP.pm then
> you should be able to call DBSETLPACKET from your script.
>
> I don't know if the call it working ie changing the packet size but it
> will execute ok. Please backup both files prior to changing incase bad
> stuff(TM) happens.
>
> I'm using a perl 5.6.1 with the latest sybperl from cpan so this may not
> be the same problem your running into.
>
> Peter
>
> --
> We assertively negotiate resource-leveling services to set us apart from
> the competition
>
>