There are some serious issues with 9.21 (check in this forum). You should upgrade to newer version.
"Maks Romih" <maks.romih@snt.si> wrote in message news:u65joc1dz.fsf@snt.si...
> From dbaccess I execute a stored procedure that is defined in another
> database on the same Informix 9.21 server with
>
> execute procedure my_db2:proc1(...);>
> I get the reply
>
> 999: Not implemented yet.>
> If I then connect to that other database my_db2 and execute the same
> statement from there, it works fine. But, strangely, when I afterwards
> connect back to the first database, it works fine as well.
>
> It seems that as soon as I restart the server, I have to at least once execute
> all my procedures by connecting to the very database, where they are defined.
>
> It seems that the procedure "is lost" also if I DROP and CREATE it.
>
> What is happening here?
>
> Is there any other way to assure that stored procedures are "known" to
> other schemas?
>
> Maks Romih