Re: CREAT PROCEDURE

Posted in 1999

Angel Gomez — Tue, 05 Oct 1999 20:16:24 PDT — source: Informix-list mailing list archive (1991-1998)

Yes, but you should use dbaccess instead of isql. >From: i.sokolsky@geac.com (Igor) >Reply-To: i.sokolsky@geac.com (Igor) >To: informix-list@iiug.org >Subject: CREAT PROCEDURE >Date: Tue, 05 Oct 1999 16:31:24 GMT > >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? > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com