Turboimage Database Enhancements - August 2001

SP Calling SP
where ParameterDeclaration =
ParameterName ParameterType [LANG = ParameterLanguage]
[DEFAULT DefaultValue] [NOT NULL] [OUTPUT]
where ResultDeclaration =
ResultType [LANG = ResultLanguage] [NOT NULL]
Example:
CREATE PROCEDURE ReportMonitor (PartNumber CHAR(20) ) AS
BEGIN
EXECUTE PROCEDURE RemoveParts(:PartNumber);
RETURN ::sqlcode ;
END ;
Constraints : Return Value from Execute Procedure within the Create Procedure
can't be assigned to variable.