|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: bulk copy failure..
Date: Dec 17 2001 4:21PM
Indeed.
But sybperl 2.14 sets the locking scheme for the temp table used in
the Sybase::BCP test to allpages, so that the test will work even if
the server has another locking scheme set as default.
Michael
Scott Zetlan writes:
> You're probably running the tests against a Sybase 12.0 or later database.
> Sybase::DBlib, from which the Sybase::BCP modules are subclassed, doesn't
> support bulk-copy functionality into tables with row-level locking schemes.
> For test purposes, you can either use an earlier version of a Sybase
> database, or change your default locking schema to ALL PAGES (I think --
> someone correct me as needed, please).
>
> For practical purposes, you'll want to use the Sybase::CTlib bulk transfer
> routines instead. There's a somewhat experimental Sybase::BLK module in the
> latest Sybperl distribution (available from CPAN); it does for Sybase::CTlib
> what Sybase::BCP does for Sybase::DBlib.
>
> Scott
>
> > -----Original Message-----
> > From: owner-SYBPERL-L@list.cren.net
> > [mailto:owner-SYBPERL-L@list.cren.net]On Behalf Of Andersson, Rickard
> > Sent: Sunday, December 16, 2001 6:14 PM
> > To: SybPerl Discussion List
> > Subject: bulk copy failure..
> >
> >
> > Hi ,
> >
> > This might be a stupid question , When i run 'make test' this is
> > the output:
> >
> > make[1]: Entering directory `/space/sybase/perl/sybperl-2.13/BCP'
> > PERL_DL_NONLAZY=1 /space/sybase/gnu/usr/local/bin/perl -I../blib/arch
> > -I../blib/lib -I/usr/local/lib/perl5/5.6.1/sun4-solaris
> > -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose);
> > $verbose=0; runtests @ARGV;' t/*.t
> > t/bcp...............Sybase message 4845, Severity 16, state 1
> > Server `TDB101'
> > Line 1
> > Bulk copy failed. Client does not have the capability to bulk
> > copy into
> > the data-only locked table '#bcp'.
> >
> > 1> insert bulk #bcp
> > bcp_init failed. at t/bcp.t line 59
> > t/bcp...............dubious
> >
> > Test returned status 255 (wstat 65280, 0xff00)
> >
> >
> > Is there anything that i can do ? ...
> >
> >
> > Best Regards
> >
> > Rickard Andersson
> > System Engineer
> > System Engineering
> > Global Operation Infrastructure, Genesys Conferencing
> > Rickard.Andersson@genesys.com
> > Direct line: +46 (0)31 710 02 84
> > Mobile: +46 (0)707 820 284
> > http://www.genesys.com
> >
> >
>
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
|
