Create Procedure on Unix command line

Hi All I can use : echo 'execute procedure test()' | dbaccess cl_default Is that possible to create Stored Procedure in the similer way. Something like that : echo ' create procedure from file_name ' | dbaccess cl_default. I can't find syntaxis of this expression Thanks Regards Igor

CREATE PROCEDURE FROM filename; Art S. Kagel Igor wrote: > > Hi All > > I can use : echo 'execute procedure test()' | dbaccess cl_default > Is that possible to create Stored Procedure in the similer way. > Something like that : echo ' create procedure from file_name ' | > dbaccess cl_default. > I can't find syntaxis of this expression > > Thanks > > Regards > > Igor

Igor, I wrote an Informix ESQL/C program that accepts a file containing the stored procedure. If an error exists, the program will tell you the character that is causing the problem. I also wrote an awk script that displays which line of code the char can be found. Kim Igor wrote in message <3895e550.16410591@news.ca.geac.com>... >Hi All > >I can use : echo 'execute procedure test()' | dbaccess cl_default >Is that possible to create Stored Procedure in the similer way. >Something like that : echo ' create procedure from file_name ' | >dbaccess cl_default. >I can't find syntaxis of this expression > >Thanks > > >Regards > > >Igor