|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Switch SEPARATOR between different BCP runs
Date: Oct 30 2003 9:29PM
On Thu, 2003-10-30 at 11:33, Lin, Arthur wrote:
>
> For the second BCP run I set
>
> $GP_BLK->config(
> FIELDS => 3,
>
> BATCH_SIZE => 6000,
>
> SEPARATOR => '\t');
>
>
>
> die "\tBCP in $ListTable failed\n" unless ( $GP_BLK->run ==
> $RowCount );
> unlink $ListFile, "$ListFile.err";
>
> But it fails because it does not take '\t' as a separator.
>
> Am I doing something wrong here to reset the separator ?
No - I think that you've hit a bug in the BLK module. I have to admit
that I don't use it myself, and I wrote the original code many years
ago...
I'll look into it.
Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.org http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html
|
