Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Jayson Pifer" <JPifer at jefco dot com>
Subject: Re: Switch SEPARATOR between different BCP runs
Date: Oct 30 2003 8:11PM

        The default is already a TAB, have you tried without the field? Or
to pass it interpolated with double quotes instead?


"Lin, Arthur" 
Sent by:
10/30/03 02:33 PM

        To:     "'Michael Peppler'" 
        cc:     "Sybperl-L Mailing List" 
        Subject:        Switch SEPARATOR between different BCP runs

For the first BCP run I set

Use Sybase::BLK;

$BCP->config(DIRECTION => IN,

        INPUT => "$FID_REPO_FILE_BCP",

        OUTPUT => "$Database..$dl_table",

        ERRORS => "$dl_table.err",

        SEPARATOR=> '\|',

        FIELDS => 27,

        BATCH_SIZE => 1000);

$RowCount = $BCP->run;

And it works.

For the second BCP run I set

                        INPUT => "$ListFile",

                        OUTPUT => "$ListTable",

                        ERRORS => "$ListFile.err",

                        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 ?

Thanks in advance for your assistance.


This message is intended only for the personal and confidential use of the
designated recipient(s) named above.  If you are not the intended
recipient of
this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited.  This
communication is for information purposes only and should not be regarded
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Lehman Brothers.  Email transmission cannot be guaranteed to
secure or error-free.  Therefore, we do not represent that this
information is
complete or accurate and it should not be relied upon as such.  All
information is subject to change without notice.

Jefferies archives and reviews outgoing and incoming e-mail.  It may be produced at the request of regulators or in connection with civil litigation.
Jefferies accepts no liability for any errors or omissions arising as a result of  transmission. Use by other than intended recipients is prohibited.