Re: Informix 5.x .Stored Procedure problem. Help !!!

Igor, I want to know if the stored procedure names are the same for both the instances ? I mean if you drop the first SP and then create the SP with the same name and new instance i.e. new hard coded path fo rthe executable. Then you will have to run update statistics for that SP ..as the optimized code of the older SP isstill in the memory. And if you call that SP with the same name then the code for the older SP is executed and not the new one. -Sumeet On Thu, 23 Mar 2000, Igor wrote: > Hi All!! > > I have a Stored Procedure , which calls executable.Everything works > fine if we working with instance 1, because path to this executable > hardcoded in SP. If we change our instance to instance 2, SP still > looking for executable in same direcory of instance 1 and fail. > For each instance we need to change our path in SP. > As far as I know there is no Trim or whatever squeeze functions in > this ver. of Informix. > How can I do my path flexible? > > Regards > > > Igor >