Informix Stored Procedure

Posted in 2003

Topics: Stored Procedures & SPL, Server Administration

Ahmer Sajjad — Fri, 12 Sep 2003 16:13:52 +0800 — source: Usenet: comp.databases.informix

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

↪ replying to Ahmer Sajjad

Nebojsa Sevo — Fri, 12 Sep 2003 17:13:20 +0200 — source: Usenet: comp.databases.informix

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

Glossary

dbaccess