|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at mbay dot net>
Subject: BCP questions
Date: Jul 17 1998 9:41PM
TSANT Santamaria, Thomas J. writes:
> Hi,
>
> Is there an easy way using the "bcp_" utilities to bulk copy in/out similar
> to the bcp -c option?
Bulk copy out is essentially a select operation, so you can do
$" = "\t";
open(OUT, ">the_table.bcp");
$dbh->sql("select * from the_table", sub { print OUT "@_\n"; });
to do a bcp OUT operation.
>
> >From reading through the documentation, it seems as though I would need to
> create a format file using multiple calls to bcp_colfmt.
>
> Is Sybase::BCP worth a look, or does it still only support DB_IN?
It still only supports DB_IN.
Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@datamig.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
|
