Configuration Mode Commands : SteelHead Configuration Commands : MS-SQL Blade Support Commands : protocol ms-sql rpc-rule rule-id app-name-regex
  
protocol ms-sql rpc-rule rule-id app-name-regex
Specify the RPC rule.
Syntax
[no] protocol ms-sql rpc-rule rule-id <rule-id <rule-id> app-name-regex <app-name> {[rpc-id <rpc-id> num-params <num-params>] | [rpc-query-regex <regex-match-for-rpc-query-string>] | [cursor-type <cursor-type>]}
Parameters
rule-id <rule-id>
Specifies the rule identification number that uniquely identifies the rule.
<app-name>
Specifies the client application name (standard string expression).
rpc-id <rpc-id>
Specifies the RPC identifier.
num-params <num-params>
Specifies the expected number of parameters in the SQL query.
rpc-query-regex <regex-match-for-rpc-query-string>
Specifies the RPC name (standard string expression).
cursor-type <cursor-type>
Specifies the cursor type for the RPC query. Depending on cursor type, the client can read forward or backward, from beginning or end, or read an arbitrary position in the result set:
•  forward-only - Only the next rows can be read. The row pointer cannot be moved back.
•  dynamic - The rows must be read in forward or reverse relative to current row pointer. The row pointer cannot be moved to an arbitrary index except for first and last positions.
•  static - The rows can be read forward or reverse or at an arbitrary position.
Usage
The no command option disables the rule.
Example
amnesiac (config) # protocol ms-sql rpc-rule rule-id 1 app-name-regex test rpc-id 2 num-params 1 rpc-query-regex test cursor-type static
amnesiac (config) # service restart
Product
SteelHead CX, SteelHead EX, SteelHead-v, SteelHead-c
Related Commands
show protocol ms-sql