Re: Create Procedure on Unix command line

Yep, something like the following should work #! /bin/ksh ( echo "create procedure eric()" cat <filename> echo "end procedure;" ) | dbaccess <dbname> 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 -- Paul Watson # WF Software # If it was easy Tel ++44 1436 674729 # Everybody could do it Fax ++44 1436 678693 # www.wfsoftware.com/informix #