HP StorageWorks Enterprise File Services WAN Accelerator 3.0.4 Command-Line Interface reference manual (AG421-96004, March 2007)

HP STORAGEWORKS EFS WAN ACCELERATOR COMMAND-LINE INTERFACE REFERENCE MANUAL 163
4 - CONFIGURATION-MODE
C
OMMANDS
Example minna (config) # protocol ms-sql rpc-arg rule-id 2 action-id 1 arg-
offset 0 expr "replace select PROJ_READ_COUNT, PROJ_LOCKED,
PROJ_READ_WRITE,PROJ_READ_ONLY, PROJ_ID, PROJ_MACHINE_ID,
PROJ_DATA_SOURCE from MSP_PROJECTS where PROJ_NAME = '$1' "
minna (config) #
protocol ms-sql rpc-rule rule-id app-name-regex
Description Specifies a RPC rule.
The no command option disables the rule.
IMPORTANT: The commands for MS-SQL support must be implemented by HP professional
services—improper use can result in undesirable effects.
NOTE: If you are interested in enabling the MS-SQL blade for other database applications,
contact HP professional services.
Syntax [no] protocol ms-sql rpc-rule <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
Example
minna (config) # protocol ms-sql rpc-rule rule-id 1 app-name-regex blah
rpc-name-regex blah num-params 1 rpc-query-regex blah cursor-type
rule-id <rule_id> Specifies the rule identification number that uniquely identifies the
rule.
app-name-regex
<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-name-regex
<regex_match_for_r
pc_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.