Runs a system procedure or a user-defined stored procedure.
[execute] [@return_status = ]
[[[server.]database.]owner.]procedure_name[;number]
[[@parameter_name =] value |
[@parameter_name =] @variable [output]
[,[@parameter_name =] value |
[@parameter_name =] @variable [output]...]]
[with recompile]
Usage
When the execute command is used to issue an RPC to a remote server, Adaptive Server issues the RPC via one of two methods. The method used to issue the RPC determines whether the work performed by the RPC can be part of an on-going transaction. The two methods are as follows:
The RPC is issued via the Adaptive Server’s site handler. This is the Adaptive Server’s default method of issuing RPCs. In this case, the RPC cannot be part of an on-going transaction.
The RPC is issued via Component Integration Services. In this case, the RPC can be part of an on-going transaction. To issue RPCs using this method, cis rpc handling must be turned on. This is done via the set command or the sp_configure system procedure.
See Also
“RPC handling and Component Integration Services”.
set in this chapter.
execute in the Adaptive Server Reference Manual.
