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: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: BCP'ing out
Date: Nov 7 1997 9:15PM

Michael Peppler wrote:
> 
> salvatore.sferrazza@ny.ubs.com wrote:
> >
> >      Anyone have any sample code to get data from a table into a text file
> >      (bcp out) using DB_OUT?  I have used DB_IN extensively, but I cannot
> >      find sufficient resources on how to do the opposite.  I already wrote
> >      a makeshift bcp out by polling the table and outputting to a text file
> >      but it tends to be very slow.
> 
> To bcp OUT you're probably better off using bcp, unless you need
> to bcp certain rows only (based on some criterion) in which
> case doing a select is exactly as fast as a bcp out.

BTW - the new 2.08_51 release should help for speed for this sort
of thing...

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler