rp_pool_remattrib

Description

Removes a connection attribute/value from a pool.

Syntax

rp_pool_remattrib pool_name, attrib, value

Parameters

pool_name

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

attrib

The name of the attribute to be removed from the pool. Table 7-9 describes the values for attrib.

Table 7-9: Attribute names for rp_pool_remattrib

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 used to match attrib.

Examples

Example 1

Removes attribute appname, with a value of “isql%” from POOL_A.

1> rp_pool_remattrib "POOL_A", "appname", "isql%"
2> go

Example 2

Removes the attribute hostname with the a value of “[Cc]rater” from POOL_A.

1> rp_pool_remattrib "POOL_A", "hostname", "[Cc]rater"
2> go

Example 3

Removes the attribute username with a value of “Moon” from POOL_A.

1> rp_pool_remattrib "POOL_A", "username", "Moon"
2> go

Usage


Messages

See also

rp_pool_addattrib, rp_pool_create, rp_pool_help