If the DirectConnect TSQL configuration property is set to SYBASE, use this command syntax to invoke RSPs:
EXECUTE 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:
EXECUTE procedurename @VARNAME1=value1, @VARNAME2=value2 ... , @VARNAMEn=valuen
With TSQL set to SYBASE, you must comply with Transact-SQL syntax for variables. In particular, be sure to prefix your variable names with the at sign (@) instead of the ampersand (&) and to separate the variables with commas.
The client application passes variable text to the RSP as a single text string; the RSP is responsible for interpreting the string. When using variable text, you can include an unlimited number of variables in the string.
There is a 32K limit for variable text string size.
If TSQL is set to PASSTHROUGH, use this command syntax to pass variable text to the RSP:
USE PROCEDURE procedurename valuestring
If TSQL is set to SYBASE, use this command syntax to pass variable text to the RSP:
EXECUTE procedurename valuestring
