Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    19

    Unanswered: DB2-PERL Stored Procedure

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    19

    Unhappy

    I didn't found anything yet.
    Is there any idea?

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •