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