Hi,

Check authorization along the entire path.
Can you post the CREATE FUNCTION statement?

Cheers
Serge


"Praveen K. Pandey "
<db2udbdba-ezmlmshield-x61340710.[Email address protected] wrote on
01/20/2006 05:38:20 AM:

> Hi all
>
> Db2 8.1.3 windows
>
> My application is on .Net .
>
> When I am calling a procedure from .NET, it is throwing the following
> error.
>
>
>
> Error Description :ERROR [42724] [IBM][CLI Driver][DB2/NT] SQL0444N
> Routine "*test" (specific name "SQL060120151303330") is implemented with
> code in library or path "...test", function "first_test" which cannot be
> accessed. Reason code: "4". SQLSTATE=42724
>
>
>
> Error Stack :at IBM.Data.DB2.DB2Connection.HandleError(IntPtr
> hHandle, SQL_HANDLE hType, RETCODE retcode)
>
> at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior
> behavior, String method)
>
> at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
>
> at
> IBM.Data.DB2.DB2Command.System.Data.IDbCommand.ExecuteReader(CommandBeha
> vior behavior)
>
> at System.Data.Common.DbDataAdapter.Fill(Object data, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
>
> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
> startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
> CommandBehavior behavior)
>
> at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
>
> at IBM.Data.DB2.DB2DataAdapter.Fill(DataSet dataset)
>
>
>
> I have recompiled the procedure and there is not much in the procedure
> .Its just doing an update.
>
> I think that db2 is not able to find the shared library for this
> procedure. How can this be accomplished?
>
> All other calls are working fine.
>
>
>
>
>
>
>
>
>
> Warm regards,
>
>
>
> Praveen Pandey
>
> MASTEK
> "Making a valuable difference"
> Mastek in NASSCOM's 'India Top 20' Software Service Exporters List.
> In the US, we're called MAJESCOMASTEK
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> Opinions expressed in this e-mail are those of the individual and
> not that of Mastek Limited, unless specifically indicated to that
> effect. Mastek Limited does not accept any responsibility or
> liability for it. This e-mail and attachments (if any) transmitted
> with it are confidential and/or privileged and solely for the use of
> the intended person or entity to which it is addressed. Any review,
> re-transmission, dissemination or other use of or taking of any
> action in reliance upon this information by persons or entities
> other than the intended recipient is prohibited. This e-mail and its
> attachments have been scanned for the presence of computer viruses.
> It is the responsibility of the recipient to run the virus check on
> e-mails and attachments before opening them. If you have received
> this e-mail in error, kindly delete this e-mail from all computers.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


DB2 & UDB email list listserv db2-l LazyDBA home page