User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise
sp_passthrough_piece procedure
Purpose To build a long SQL statement for passthrough.
Syntax sp_passthrough_piece string
Argument Description
string A piece of a statement to be executed in passthrough
mode.
See also “sp_passthrough procedure” on page 402
“sp_passthrough_stop procedure” on page 405
“sp_passthrough_subscription procedure” on page 406
“sp_passthrough_user procedure” on page 407
“PASSTHROUGH statement” on page 368
Description The “sp_passthrough procedure” on page 402 is used to send statements
directly to a set of remote users. Statements that are longer than 255
characters have to be built up piece by piece.
To build and send a long SQL statement, call sp_passthrough_piece for all
but the final piece of the statement, and then call sp_passthrough for the
final piece. This completes and replicates the statement.
All pieces of a passthrough statement must be built within a single
transaction.
Example
♦ The following statements send a long passthrough statement to the
current list of passthrough recipients:
403