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
> 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
I'll look into it.
Michael Peppler Data Migrations, Inc.
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html