RE: Informix Stored Procedure
update statistics ???
-----Mensaje original-----
De: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]En
nombre de Nebojsa Sevo
Enviado el: viernes 12 de septiembre de 2003 17:13
Para: informix-list@iiug.org
Asunto: Re: Informix Stored Procedure
On Fri, 12 Sep 2003 16:13:52 +0800, "Ahmer Sajjad"
<ahmer@conceptfert.com.au>
wrote:
>
>Hello!
>
>I am using Informix 7 se and having problems with updating the stored
>procedure everytime I run it.
>
>Basically, I have made changes to the sql file that drops and create a
store
>procedure, but it still shows outputs from the old copy of the same stored
>procedure. The only way I am able to see changes in the results is by
>creating a stored procedure with a different name. I am using DBACCESS to
>create and execute my stored procedure.
I think that you have to close database after makeing changes to SP and open
DB
again.
nebojsa
------------------------------------
Remove spam block (DELETE_) to reply
sending to informix-list