Re: CREAT PROCEDURE

Posted in 1999

Sujit.Pal@bankofamerica.com — Tue, 05 Oct 1999 15:43:15 -0700 — source: Informix-list mailing list archive (1991-1998)

Igor Yes, just replace isql with dbaccess. HTH Sujit i.sokolsky@geac.com (Igor) on 10/05/99 09:31:24 AM Please respond to i.sokolsky@geac.com (Igor) To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: 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?