|
|
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:46PM
On Fri, 2002-06-21 at 06:36, Scott Zetlan wrote:
> Ok, I've confirmed a couple things:
>
> 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.
Documentation fixed in my copy.
> > -----Original Message-----
> > From: owner-SYBPERL-L@list.cren.net
> > [mailto:owner-SYBPERL-L@list.cren.net]On Behalf Of Scott Zetlan
> > Sent: Thursday, June 20, 2002 5:35 PM
> > To: SybPerl Discussion List
> > Subject: RE: A patch proposal to the NULL-value problem on blk_rowxfer
> >
> >
> > Hmm -- I seem to recall that Sybase::BCP and Sybase::BLK will both assume
> > empty strings are null values unless you set a NULL_PATTERN option during
> > config. However, I will have to check on that.
> >
> > Scott
> >
> > > -----Original Message-----
> > > From: owner-SYBPERL-L@list.cren.net
> > > [mailto:owner-SYBPERL-L@list.cren.net]On Behalf Of Michael Peppler
> > > Sent: Thursday, June 20, 2002 5:21 PM
> > > To: SybPerl Discussion List
> > > Subject: Re: A patch proposal to the NULL-value problem on blk_rowxfer
> > >
> > >
> > > On Thu, 2002-06-20 at 08:53, Masatsuyo Takahashi wrote:
> > > >
> > > > To summarize,
> > > > [Rule1] undef is the only value that is converted to NULL.
> > > > [Rule2] defined values are always also defined values in Sybase
> > >
> > > I think that that is consistent.
> > >
> > > > You have to be aware of the fact that you get DEFINED values
> > > > (i.e. ""s) when you split a CSV line such as
> > > > ,,,,,
> > > > which doesn't seem to define any values.
> > >
> > > Indeed. I *think* that Sybase::BCP and/or Sybase::BLK will do the
> > > "right" thing here, but I may be wrong.
> > >
> > > Scott?
> > >
> > > 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!
|
