|
|
sybperl-l Archive
Up Prev Next
From: "Scott Zetlan" <scottzetlan at aol dot com>
Subject: RE: bulk copy failure..
Date: Dec 17 2001 2:24PM
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
>
>
|
