If the DirectConnect TSQL configuration property is set to PASSTHROUGH, use this command syntax to invoke RSPs:
USE PROCEDURE procedurename
If you pass variables to the RSP, you must also supply the appropriate arguments in the invoking statement, and the form of the arguments must match the SQL transformation level. See your Transact-SQL manual for more information on variables and arguments.
Use this command syntax to pass keyword variable values to the RSP:
USE PROCEDURE procedurename &VARNAME1=value1 &VARNAME2=value2 ... &VARNAMEn=valuen
The client application passes variable text to the RSP as a single text string; the RSP is responsible for interpreting the string.
If the DirectConnect TSQL configuration property is set to PASSTHROUGH, use this command syntax to pass variable text to the RSP:
USE PROCEDURE procedurename valuestring
There is a 32K limit for variable text string size for
DB2 Access Service. This limit is not valid for TRS Access Service.
