Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
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 


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 []
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, wrote:
> Thanks Michael.
> Is this available in perl 5.004.04 ? i tried
> and 
> DBSETLPACKET($bcp, 4096);
> in my script and it shouted 
> Undefined subroutine &main::DBSETLPACKET called at mtm_cons_load line 115.
> ???

	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/ and Sybase/ 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.


We assertively negotiate resource-leveling services to set us apart from 
the competition