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 4:12PM

got it to work by using 

Sybase::DBlib::DBSETLPACKET($packetsize);

but it throws an error:

DB-Library error:
    Packet size of 8192 not supported -- size of 512 used instead.

although when i use isql / bcp from UNIX i am able to use "-A 4096"

the "max network packet size" config parameter is set to 8192.

Any clues ?

- Mitesh

-----Original Message-----
From: Peter Sinnott [mailto:psinnottie@aol.com]
Sent: Friday, September 13, 2002 4:53 PM
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