Re: Returning Value
Posted in 1999
Topics: Stored Procedures & SPL
Although none zero exit codes from "test" can be detected I've never found this to be particularly consistence across OS's and it's difficult to differentiation between a valid return code and a real error. Your best bet is to insert the data into a table and process the table.
Paul Watson
WF Software Ltd
Tel +44 1436 674729
Fax +44 1436 678729
www.wfsoftware.co.uk
>>> Igor <i.sokolsky@geac.com> 07/21/99 06:04pm >>>
>Hi All
>
>I have follow procedure :
>
>
>CREATE PROCEDURE db_test22()
>RETURNING INTEGER;>DEFINE Ret INTEGER;
>SYSTEM "/home2/igor/ngen/dev/bin/test ";
>RETURN Ret;
>END PROCEDURE;
>
>1. "test" is my executable file, which has to return me some
> value.How can I pick up this value in Stored Procedure.
>2. In case I have few returns value, how can I get tham from my
>"test" file.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************