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.

Pls help.

Thanks,

Ahmer


sending to informix-list

Ahmer Sajjad wrote:

Have you updated statistics for the procedure after recreating it?

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

sending to informix-list

On Fri, 12 Sep 2003 16:13:52 +0800, "Ahmer Sajjad" <ahmer (AT) conceptfert (DOT) com.au>
wrote:

I think that you have to close database after makeing changes to SP and open DB
again.

nebojsa
------------------------------------
Remove spam block (DELETE_) to reply

update statistics ???

-----Mensaje original-----
De: owner-informix-list (AT) iiug (DOT) org [mailtowner-informix-list (AT) iiug (DOT) org]En
nombre de Nebojsa Sevo
Enviado el: viernes 12 de septiembre de 2003 17:13
Para: informix-list (AT) iiug (DOT) org
Asunto: Re: Informix Stored Procedure


On Fri, 12 Sep 2003 16:13:52 +0800, "Ahmer Sajjad"
<ahmer (AT) conceptfert (DOT) com.au>
wrote:

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