mdaetwyler@gmail.com wrote:
> Hi all
> I am trying to call a DB/2 v8.2 stored procedure from Perl DBI and am
> getting an error message telling me, that the routine could not be
> found in the library path.
>
> [IBM][CLI Driver][DB2/NT] SQL0444N Routine "*_deposit" (specific name
> "SQL050519190148810") is implemented with code in library or path
> "\finban.cac_deposit", function "finban.cac_deposit" which cannot be
> accessed. Reason code: "4". SQLSTATE=42724
>
> Since 8.2 stores stored procedures internaly as byte code, the libaries
> can indeed not be found in sqllib/FUNCTION/ROUTINE.
>
> I tried to grant EXECUTE rights to all users on the packages found in
> syscat.packages but this changed nothing.
>
> Im am working with v8.2. on Windows, ActivePerl 5.61(638) and DBD-DB2
> 0.76 and DBI 1.34.
The problem you have is independent of PERL.
Now in V8.2 SQL Procedures which are CREATEd in V8.2 ar eall internal.
But external (java, C, ..) procedures or SQL Procedures created prior to
V8.2 still have DLLs.

Cheers
Serge


--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab