Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Diego Morales — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.