Chapter 5: Testing and invoking an RSP

Using the SYBASE mode command

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.

Passing keyword variables

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.

Passing variable text

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 
```

View this book as PDF