creating a stored procedure in ISQL for Informix 5 onlin 
Author Message
 creating a stored procedure in ISQL for Informix 5 onlin

     Greg,

     You can't create SPL's in ISQL you get syntax errors and other stuff
     you have to use DBACCESS.

     Regards

     David Ashby

______________________________ Reply Separator _________________________________
Subject: creating a stored procedure in ISQL for Informix 5 online

Date:    13/12/97 10:55 PM

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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Creating isql batch file to run stored procedure

2. creating stored procedures w/ isql 4.11

3. creating stored procedures using ISQL

4. Problem in creating stored procedure in ISQL

5. Creating a Stored Procedure in a Stored Procedure?

6. Creating stored procedures in a stored procedure?

7. sybase stored procedure into informix stored procedure

8. sybase stored procedure into informix stored procedure

9. How to create stored sql procedure for Informix database

10. Creating procedures with isql


 
Powered by phpBB® Forum Software