Re: creating stored procedures using ISQL

On 14 Dec 1997, Greg Laurin wrote: > This is something that sounds to simple but I can't create a stored > procedure in ISQL Correct. ISQL thinks statements are terminated by semi-colons. CREATE PROCEDURE statements have semi-colons in the middle of them,but ISQL doesn't know about this, so it sends the CREATE PROCEDURE statement up to the first semi-colon to the database. Your empty SP therefore worked -- anything meaningful doesn't. As already advised, use DB-Access. David (O Guardian of the FAQ): if this is not already in the FAQ, please add it as a suitable item... Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>