After a connection is created, you can change its configuration parameters with the alter connection command. Refer to Table 7-1 for a list and description of configuration parameters that affect connections.
alter connection lets you change the attributes of a database connection. Use this command, for example, if you have added an Adaptive Server database connection using Sybase Central or rs_init, and then decide that you want the database connection to use a derived function-string class instead of a system-provided class. The syntax for alter connection is:
alter connection to data_server.database {
set function string class [to] function_class |
set error class [to] error_class |
set password [to] passwd |
set log transfer [to] {on | off} |
set database_param [to] 'value'} |
set security_param to {‘required’ | ‘not_required’} |
set security_services [to] “default’
}
You indicate the data server and database that is connected to the Replication Server and specify one or more of the attributes to change. These include:
function_class – the function-string class to use with the database connection.
error_class – the error class to use for handling database errors.
passwd – the new password to use with the login name for the database connection.
log transfer on – allows transactions to be sent, using this connection, to the Replication Server.
log transfer off – stops transactions from being sent, using this connection, from a primary database to the Replication Server.
database_param – updates a configuration parameter that affects connections. See Table 7-1 for a list of parameters you can change.
security_param – updates a network security configuration parameter that affects connections. See “Managing network-based security” for a list and description of parameters you can change.
set security_services [to] ‘default’ – resets all network-based security features for the connection to “not required.” See “Managing network-based security” for a description of network security for Replication Server.
