Executing Stored Procedures from Unix prompt
How do I execute a stored procedure from the unix prompt without using a C program? Thanks. teresa_murphy@co.summit.co.us
Create a ????.sql file with the appropriate EXECUTE [procname] statement and
then...
[dbaccess|isql|isqlrm] [dbname] < ???.sqlfile
or
[dbaccess|isql] [dbname] -
this will give you a
> {Prompt}
Now EXECUTE [procname];
<CTRL-D} {to exit}
Hope this helps
Terry Hillick
CSCSi
Teresa Murphy wrote:
> How do I execute a stored procedure from the unix prompt without using a C
> program?
>
> Thanks.
>
> teresa_murphy@co.summit.co.us
Teresa Murphy wrote:
> How do I execute a stored procedure from the unix prompt without using a C
> program?
Well, you could try:
echo 'EXECUTE procedure(...)' | dbaccess databasename
-Richard