sybperl-l Archive

From: "Mondal, Subrata" <SMondal at imf dot org>
Subject: RE: Sybase BCP
Date: Feb 28 2002 2:08PM

X-VM-v5-Data: ([nil nil nil t nil nil nil nil nil] ["7191" "Thursday" "28"
	"February" "2002" "09:08:33" "-0500" "Mondal, Subrata" "SMondal@imf.org"
	nil "167" "RE: Sybase BCP" "^From:" nil nil "2" nil "Sybase BCP" (number "
	" mark " F   Mondal, Subrata   Feb 28  167/7191  " thread-indent "\"RE:
	Sybase BCP\"\n") nil nil] nil)
Received: from taku.cren.net (taku.cren.net [128.8.10.25]) by
	troll.peppler.org (8.11.6/8.11.6) with ESMTP id g1SE9v801410 for
	; Thu, 28 Feb 2002 06:09:57 -0800
Received: from localhost (localhost [127.0.0.1]) by taku.cren.net
	(Pro-8.9.3/Pro-8.9.3) with SMTP id JAA18687; Thu, 28 Feb 2002 09:09:18
	-0500 (EST)
Received: from csnt1x.imf.org (csnt1x.imf.org [206.229.236.58]) by
	taku.cren.net (Pro-8.9.3/Pro-8.9.3) with SMTP id JAA18681 for
	; Thu, 28 Feb 2002 09:09:11 -0500 (EST)
Received: by csnt1s.imf.org with Internet Mail Service (5.5.2653.19) id
	<1ZZ6JWLZ>; Thu, 28 Feb 2002 09:08:36 -0500
Message-ID: <100C11F5BAC84C4CAC8080A3DB2784EC217F6B@mlsswn02p.WAS.INT.IMF.ORG>
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: multipart/mixed; boundary="------------InterScan_NT_MIME_Boundary"
Reply-To: SYBPERL-L@list.cren.net
X-Listprocessor-Version: 8.2.09/990901/11:28 -- ListProc(tm) by CREN
X-Filter: mailagent [version 3.0 PL73] for mpeppler@peppler.org
From: "Mondal, Subrata" 
Sender: owner-SYBPERL-L@list.cren.net
To: SybPerl Discussion List 
Subject: RE: Sybase BCP
Date: Thu, 28 Feb 2002 09:08:33 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--------------InterScan_NT_MIME_Boundary
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1C061.68239FFB"

------_=_NextPart_001_01C1C061.68239FFB
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Tony:
Can you post the URL please .
 
Thanks
Subrata
 

-----Original Message-----
From: Scott Zetlan [mailto:scottzetlan@aol.com]
Sent: Thursday, February 28, 2002 8:55 AM
To: SybPerl Discussion List
Subject: RE: Sybase BCP


Yes, still true, and yes, you can always call the Sybase bcp utility.  But
then you wouldn't be able:
 -- to reorder the columns based on a column heading record;
 -- to install your own callback function to eliminate records you don't
want or modify those you do;
 -- to use a regular expression as a field separator;
 -- nor to identify the individual rows that don't transfer properly instead
of failing an entire batch.
 
If you don't need to do any of that, just call the Sybase utility -- but
don't use system(); open a pipe instead:
open (BCP, "bcp... |");
 
That way, you can capture the output and determine how many rows were
loaded.  With system, you only get a return code.
 
Scott

-----Original Message-----
From: owner-SYBPERL-L@list.cren.net [mailto:owner-SYBPERL-L@list.cren.net]On
Behalf Of Ho, Tony
Sent: Thursday, February 28, 2002 8:33 AM
To: SybPerl Discussion List
Subject: Sybase BCP


Hi guys
I came across the following URL regarding Sybase BCP for Perl.
It mentions The current implementation seems to run about 2.5 to 3 times
slower than plain bcp
Is that still true ?
 
So, I guess it would be better to call the UNIX BCP command by setting in my
perl code:
 
system("bcp....");
 
Cheers
Tony
 


------_=_NextPart_001_01C1C061.68239FFB
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit








Tony:
Can 
you post the URL please .
 
Thanks
Subrata
 

  
-----Original Message-----
From: Scott Zetlan 
  [mailto:scottzetlan@aol.com]
Sent: Thursday, February 28, 2002 8:55 
  AM
To: SybPerl Discussion List
Subject: RE: Sybase 
  BCP


  
Yes, 
  still true, and yes, you can always call the Sybase bcp utility.  But 
  then you wouldn't be able:
  
 -- to reorder the columns based on a column heading 
  record;
  
 -- to install your own callback function to eliminate records you 
  don't want or modify those you do;
  
 -- to use a regular expression as a field 
  separator;
  
 -- nor to identify the individual rows that don't transfer 
  properly instead of failing an entire batch.
  
 
  
If 
  you don't need to do any of that, just call the Sybase utility -- but don't 
  use system(); open a pipe instead:
  
open 
  (BCP, "bcp... |");
  
 
  
That 
  way, you can capture the output and determine how many rows were loaded.  
  With system, you only get a return code.
  
 
  
Scott
  

    
-----Original Message-----
From: 
    owner-SYBPERL-L@list.cren.net [mailto:owner-SYBPERL-L@list.cren.net]On 
    Behalf Of Ho, Tony
Sent: Thursday, February 28, 2002 8:33 
    AM
To: SybPerl Discussion List
Subject: Sybase 
    BCP


    
Hi guys
    
I came across the following URL regarding 
    Sybase BCP for Perl.
    
It mentions The current implementation seems to run 
    about 2.5 to 3 times slower than plain bcp
    
Is that still 
    true ?
    
 
    
So, I guess it 
    would be better to call the UNIX BCP command by setting in my perl 
    code:
    
 
    
system("bcp....");
    
 
    
Cheers
    
Tony
    
 

------_=_NextPart_001_01C1C061.68239FFB--

--------------InterScan_NT_MIME_Boundary--