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: "Lin, Arthur" <arthur at lehman dot com>
Subject: RE: Switch SEPARATOR between different BCP runs
Date: Oct 30 2003 8:17PM

Jayson,
 
I did try both your suggestion and it still does not work.
Thanks anyway.
 
Regards,
Arthur
 
-----Original Message-----
From: Jayson Pifer [mailto:JPifer@jefco.com] 
Sent: Thursday, October 30, 2003 3:11 PM
To: Lin, Arthur
Cc: 'Michael Peppler'; owner-sybperl-l@peppler.org; Sybperl-L Mailing List
Subject: Re: Switch SEPARATOR between different BCP runs



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

        --Jayson 




	"Lin, Arthur"  
Sent by: owner-sybperl-l@peppler.org 


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

 $GP_BLK->config(                                                        
                       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.


Regards,
Arthur
                                         

----------------------------------------------------------------------------
--
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 as
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 be
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.


------------------------------------------------------------------------------
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 as
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 be
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.