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