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