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]
When execute 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 ongoing 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 set or sp_configure.
“RPC handling and Component Integration Services”
set in this chapter
execute in the Reference Manual
