Up Prev Next
From: "Sabherwal, Balvinder (MBS)"
<Balvinder dot Sabherwal at mortgagefamily dot com>
Date: Aug 9 2004 3:30PM
I have a script as below that I'm trying to execute. I want to do a select *
from one table and insert into another table without writing the data to a
flat file. When I execute the script, I get error as below
Connection OK to Server
INPUT parameter is a ref but not a CODE ref at x.pl line 24
What is that I'm missing here? Is it doable what I'm trying in here?
Thanks for all your help.
$dbh = Sybase::CTlib->ct_connect('MyUser','password',SYB_UNIX);
if($dbh eq undef)
print "Connection Failed to Server\n";
print "Connection OK to Server\n";
$bcp = new Sybase::BLK MyUser, 'password', SYB_UNIX;
$bcp->config(INPUT => getdata($dbh),
OUTPUT => 'BatchControl.dbo.b',
BATCH_SIZE => 200);
( $dbh ) = @_;
$data=$dbh->ct_sql('select * from BatchControl.dbo.a');