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: 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