Contents Index sp_passthrough procedure sp_passthrough_stop procedure

SQL Remote User's Guide
  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

sp_passthrough_stop procedure

sp_passthrough_subscription procedure

sp_passthrough_user procedure

PASSTHROUGH statement

Description 

The sp_passthrough procedure 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 

Contents Index sp_passthrough procedure sp_passthrough_stop procedure