sybperl-l Archive

From: "Ellery, Michael BGI SF" <Michael dot Ellery at barclaysglobal dot com>
Subject: BCP -- bcp_run
Date: Mar 26 1999 1:08AM

I can't figure this one out...I'm using the Sybase::BCP package and I do
something like this:

--------------------------------------
    # Construct a BCP object

    $bcph = new Sybase::BCP $DB_USER, $DB_PWD, $SERVER;
    $bcph -> Sybase::BCP::config(
               INPUT => $bcp_file,
               OUTPUT => "$SCRATCH..wk_index_load",
               DIRECTION => 'IN',
               SEPARATOR => $outsep,
               ERRORS => "$CONFIG{$Config_Base_Name}->{LOG_DIR}/bcp.err",
             );
    
    # And BCP it in. Check the number of rows sent.
    
    $bcp_rows_sent = $bcph->Sybase::BCP::run;
----------------------------------------

...and $bcp_rows_sent always comes back as 1.  The docs indicate that run
should return the number of row sent.  What am I missing here?

TIA,

Michael Ellery
Barclays Global Investors
45 Fremont St., 6th Floor #102
San Francisco, CA  94105
(415) 908-7234 [PH],  (415) 597-2352 [FAX]
Email:  michael.ellery@barclaysglobal.com