Re^6: Sybase::BCP

Well, the good news is that the bcp from the command line works fine... 63 rows of data loaded properly.

The bad news is, we apparently do not have Sybase::BLK installed on our system. Changing my code to:

use Sybase::BLK;

$bcp = new Sybase::BLK $user, $pwd, $server, $appname;
$bcp->config(INPUT => $tmp_file,
             OUTPUT => 'css..tmp_site_term',
             ERRORS => 'bcp_errors');
$bcp->run;
[download]

I get an error: Can't locate Sybase/BLK.pm in @INC (@INC contains: /usr/perl5/5.00503/sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_perl/5.005/sun4-solaris /usr/perl5/site_perl/5.005 .)

Should I pursue using the other bcp routines?

Comment on Re^6: Sybase::BCP Download Code

Replies are listed 'Best First'.
Re^7: Sybase::BCP by mpeppler (Vicar) on Nov 03, 2004 at 16:36 UTC
OK - so you appear to have an older version of sybperl installed that didn't include Sybase::BLK. At this point you have a couple of possibilities: You can simply use the bcp binary to load the data. If the file is not likely to become very big (say a couple of thousand rows) you could simply insert the data with a normal SQL insert. You can try to get Sybase::BCP to work. Personally I'd probably just run bcp directly using something like `system("bcp css..tmp_site_term in $tmp_file -c -U$user -P$pwd -S$serve +r -e$tmp_file.err");` [download] Michael	[reply] [d/l]

Replies are listed 'Best First'.

Re^7: Sybase::BCP
by mpeppler (Vicar) on Nov 03, 2004 at 16:36 UTC

At this point you have a couple of possibilities:

You can simply use the bcp binary to load the data.
If the file is not likely to become very big (say a couple of thousand rows) you could simply insert the data with a normal SQL insert.
You can try to get Sybase::BCP to work.

system("bcp css..tmp_site_term in $tmp_file -c -U$user -P$pwd -S$serve
+r -e$tmp_file.err");
[download]

[reply]
[d/l]