rp_msg  rp_pool_addserver

Chapter 6: Registered Procedures

rp_pool_addattrib

Description

Adds connection attribute/value pair to a pool.

Syntax

rp_pool_addattrib pool_name, attrib, value

Parameters

pool_name

Identifies the name of the pool to which the attribute/value pair is to be added.

attrib

The name of the attribute to be added to the pool. Table 6-3 shows the valid values.

Table 6-3: Attribute names for rp_pool_addattrib

Attribute

Description

username

value must match the user name of an incoming client connection.

appname

value must match the application name identified by the incoming client connection.

hostname

value must match the host machine name identified by the incoming client connection.

value

A standard SQL wildcard expression use to match attrib.

Examples

Example 1

Routes any connection created by a user name beginning with “Sybase” or “sybase” to POOL_A.

1> rp_pool_addattrib "POOL_A", "username", "[sS]ybase%"
2> go

Example 2

Routes any connection created with an application name of “isql” to POOL_A.

1> rp_pool_addattrib "POOL_A", "appname", "isql"
2> go

Example 3

Routes any incoming connection from this particular host to POOL_A.

1> rp_pool_addattrib "POOL_A", "hostname",
  "name of host"
2> go

Usage


Messages

See also

rp_pool_create, rp_pool_help, rp_pool_remattrib





Copyright © 2005. Sybase Inc. All rights reserved. rp_pool_addserver

View this book as PDF