Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: RE: A patch proposal to the NULL-value problem on blk_rowxfer
Date: Jun 21 2002 2:48PM

On Fri, 2002-06-21 at 06:41, Scott Zetlan wrote:
> > -----Original Message-----
> > From: Scott Zetlan []
> > Sent: Friday, June 21, 2002 9:36 AM
> > To:
> > Subject: RE: A patch proposal to the NULL-value problem on blk_rowxfer
> >
> >
> > 1. The documentation clearly states that SEPARATOR => '|' in the
> > config hash will allow you to use pipes as separators, when in
> > fact it absolutely has to be SEPARATOR => '\|'.  I recommend the
> > documentation be changed to include the '\' character, and a note
> > added to indicate why it's there.
> It also appears that when a record fails, the error file created contains
> the regular expression as the separator, not the expression matched.  For
> example, if the record "a||b" is separated as above, and fails to transfer
> for some reason, the error file includes the record "a\|\|b", which couldn't
> be run back through the same program to reload.

Rats. Off-hand I don't see an obvious way of fixing that - but I'll try
to figure something out (guess I need something that does the opposite
of quotemeta...)

Michael Peppler / / / ZetaTools, Inc /
ZetaTools: Call perl functions as Sybase stored procedures!