mmolowny
01-22-03, 11:11
| Hi, Firstable I beg excuses for my english. I explain you my problem. I hope there will be anyone who can help me :-) 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(...)" and everything works well. 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. There are any environment variables I could have forgotten (there will be millions)? Thank you very much in advance... Miguel |