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