sybperl-l Archive

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Message from bcp
Date: Sep 11 1997 4:36PM

1FA91-Rolf Kamp wrote:
> 
> Hi:
>         I am using Sybperl's bcp as:
> 
>                 use Sybase::BCP;
>                 $bcp=new Sybase::BCP $user, $passwd, $db;
>                 $bcp->config(INPUT => "$ENV{DATADIR}/$table",
>                         OUTPUT => "udb..$table",
>                         SEPARATOR => ',');
>                 $bcp->run;
> 
>         Everything work well and all rows get inserted, but each
>         time it runs I get a message like:
> 
> 4 rows copied.
> Clock Time (ms.): total = 194    Avg = 48     (20.62 rows per sec.)
> 
>         This is messing up programs that run my perl script and count
>         on only certain things coming to stdout.  Is there any way I can
>         either shut off the message from bcp, or redirect it?

I think you need to play with the message handler.

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler