CREAT PROCEDURE

Hi All I need to send to integration my stored procedure. We never did it before.I know how to write shell to open new table, but I don't know how to do it with stored procedure. To create table we do following: echo " CREATE TABLE sls_temp ( patron_id integer not null, grp_barcode char(25) not null )LOCK MODE_ROW; " | isql $CLSI_DBNAME Is it possible to write CREATE PROCEDURE in the similar way?

Yes it is. However, isql does not understand CREATE PROCEDURE, it only supports Informix 4.xx SQL syntax. You must use dbaccess instead of isql (or Jonathan Leffler's sqlcmd utility) to create a stored procedure. Art S. Kagel Igor wrote: > > Hi All > > I need to send to integration my stored procedure. > We never did it before.I know how to write shell to open new table, > but I don't know how to do it with stored procedure. > To create table we do following: > echo " CREATE TABLE sls_temp > ( > patron_id integer not null, > grp_barcode char(25) not null > )LOCK MODE_ROW; " > | isql $CLSI_DBNAME > Is it possible to write CREATE PROCEDURE in the similar way?