Hi,
I tried in the past to make perl work with the loader tool, but it
always failed with
undefined symbol: Perl_safemalloc at
/usr/lib/perl5/5.8.1/i586-linux-thread-multi/DynaLoader.pm line 229.
Now because I have no other choice left I have to get it to work.
If I go look at line 229 I see a few line above the message that often
errors are reported to come from this part of code but actually it
mostly come from the initialisation code of the extension file.
Is the loader tool the problem then?
What else did I try:
I downloaded the latest Maxdb release, extracted the perl modules and
copied them over to my current database directory.
Run instperl.pl
Tried again but failed, as did the original modules. With the same
error.
If somebody got this to work, can you please please tell me how. I'am
now migrating data from one database to another using plain select
insert sequences run in a perl script, and it ain't just workable to
move altogether 25 million line this way.
This time, I'm in desperate need for help :-(
Regards,
Filip Sergeys
PS. This is my testscript that uses SAP::DBTech::loader. It is actually
a composition of the examples in the documentation.
#!/usr/bin/perl
use warnings;
use strict;
use SAP::DBTech::loader;
# Parse the call arguments
# --------------------------
$user_name = $ARGV[0];
$password = $ARGV[1];
$database_name = $ARGV[2];
$data_path = $ARGV[3];
$server_node = "localhost";
# Create a database session for the Loader
# -------------------------------------------
$session = loader::Loader ($server_node, $database_name);
# Log on to the database instance
# --------------------------------
$session->cmd("use user $user_name $password;");
# Example of Exception Handling
# -----------------------------
eval{
$loadrc=$session->sql ("DATALOAD TABLE t_test ".
"groupid 1 ".
"name 2 ".
"instream file '/tmp/test.txt' seperator ';'
delimiter '' NOHEADER" );
print "$loadrc\n";}
if ($@){
print "command failed: [EMAIL PROTECTED]";
}
# End the database session
# ----------------------------
undef $session
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
