There are a few different errors that can be returned depending on the
nature of the failed lookup.

Knut Stolze wrote:

> Sean McKeough <mckeough@nospam.ca.ibm.com> wrote:
>
>
>>Paul,
>>
>>Blair is correct, however note that for non-built udfs and stored procs
>>must be move manually after the restore (known function requirement).
>
>
> I don't know the details as well as you do, Sean, but wouldn't you get a
> SQL0444 in that case??
>
>
>>>>SQL0440N No authorised routine named RTRIM of type FUNCTION
>>>>having compatible arguments was found SQLSTATE=42884
>
>