Ahmer Sajjad 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.

Have you updated statistics for the procedure after recreating it?

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list