Re: Executing Stored Procedures from Unix prompt

Posted in 1999

have01@handelsbanken.se — Wed, 7 Apr 1999 17:20:59 -0400 — source: Informix-list mailing list archive (1991-1998)

Use dbaccess [dbname] - < [sqlscript file containing stored procedure] For eg : let us say, storedproc.sql is the sql script file name DB1 is the database name then $ dbaccess DB1 - < storedproc.sql the output can be redirected appropriately to a file. HTH Harinath Venkata, Svenska Handelsbanken, New York.