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.
Jay Aymond — — source: Informix-list mailing list archive (1991-1998)
"Greg Laurin" <glaurin@coldstorage.com> wrote:
>This is something that sounds to simple but I can't create a stored
>procedure in ISQL
>
>I tried -
>CREATE PROCEDURE test()
>END PROCEDURE;>
>and it works, OK I tried -
>
>CREATE PROCEDURE test(ltqty INT)>
>let ltqty = ltqty / 2; -- I also tried it without the ;
>
>END PROCEDURE;
>
>and it gives me a syntax error, Why ?
>
>
>I have looked in all the manuals for I4GL 4.01 and ISQL 4.02 and there is
>nothing, absolutely nothing on stored procedures :(
>
>Thanks In advance for helping me with this simple and dump question
>
>Doug Gray
>penngray@netrover.com
>
>
>
Try using DBACCESS instead of ISQL.
***************************************************************
Jay Aymond
United Life & Annuity Insurance Company
Email: jay@ulife.com
***************************************************************
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.