sybperl-l Archive
Up Prev Next
From: Charles Zhao <charles dot zhao-next at attws dot com>
Subject: Re: DBlib bcp in/out sample
Date: Aug 23 1999 5:28PM
I would not suggest using DBLib bcp calls if your data is huge. If you are
handling large data set, using direct sybase bcp calls is more efficient. An
example (bcp in) is:
$bcpCommand = "$ENV{SYBASE}/bin/bcp $db..$Table in $inFile -f $fmtFile -U
$user -P $psw -S $DBSERVER -b $batchSize -m $maxNumOfErrors -e $errFile";
@output = `$bcpCommand`;
REF: Sybase utilities manual.
Points to Know:
1. Failover roll back;
2. If you have bcp v.11, go back use v10. as v11 has a bug.
Charles Zhao
|
