![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The stored procedure STUB builds two result sets. We map the first of them with the following SLK definition:
For stored procedure result set mappings, external table characteristics (name, qualifier, owner) are ignored at runtime; however, it is helpful sometimes to have these values in the definition. In the example, they assist in defining the mapping, as they refer to the table used by the procedure to build the result set.
_ END; |
CALL STUB(2,'') CALL STUB('',3) EXECUTE STUB('',3) TRANSFERCALL STUB('',3)
After EXECUTE and TRANSFERCALL statements, you can use the statement CALL MSGLOG(GETENMSG) to extract the return value produced by the procedure. GETENDMSG returns a NULL if the definition contains no return value. In all cases, upon return of control after the execution of the procedure, the current occurrence of the SLK table STUB contains the values of the procedure parameters (including the return value) as set by the procedure.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |