Hi,
I have a problem with PERL and the stored procedures.
I can't execute
my $sth_proc = $dbh->prepare("call
db2inst1.sert_resource(?,3,?,?,?,?)");
$sth_proc->bind_param(1,$LOG IN_NAME);
$sth_proc->bind_param(2,$cpu);
$sth_proc->bind_param(3,$macc);
$sth_proc->bind_param(4,$anno);
$sth_proc->bind_param(5,$date);
$sth_proc->execute() or die "Can't do:" , $dbh->errstr(),"\n";
He says me the next message:
Can't do:[IBM][CLI Driver][DB2/LINUX] SQL10013N The specified library
"/msys/dbhome/db2inst1/sqllib/function/db2inst1.insert_resource" could
not be loaded.
The strange thing is that I can call the stored procedure from the
command line with db2 "call insert_resource(...)" . I can also do from
my PERL script system ("call \"db2inst1.insert_resource\"") and it works
well.
When I do from the command line db2 "invoke insert_resource", I have the
same error message.
Can anybody help me with this problem?
There are any environment configuration (variables) I could have
forgotten?
Thank you very much in advance...
Miguel
