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
|
