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 copies/out of space?
Date: Sep 6 2002 10:24AM

On Tue, 2002-09-03 at 07:28, Scott Zetlan wrote:
> Here's the problem -- the database ran out of space on the default segment
> (data, not log), and therefore could not accept batches of records.  As a
> result, data that I attempted to transfer and commit did not get saved in
> the target tables.  That's perfectly normal -- what's odd is the application
> didn't receive an error message.  I checked return codes from blk_rowxfer
> and blk_batch, and both returned CS_SUCCEED every time.

You mean blk_done(), right?

Did you check the number of rows actually committed after blk_done()
returns?

I haven't played with in-line error handling at all, so I don't really
know how it works, but I suspect that you need to check the number of
rows affected to catch that sort of error.

Michael
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!