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:14PM

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.

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