alter connection

Changes the attributes of an existing connection profile.

Syntax

alter connection connection_name 
[set agent [{to|=}]agent_name]
[and set host  [{to|=}] host] 
[and set port [{to|=}] port]
[and set database [{to|=}] database_name]
[and set user [{to|=}] username]
[and set password [{to|=}] password]
[and set desc [{to|=}] description]

To alter node information for a cluster connection:

alter connection  connection_name
with node 
set host [{to|=}] host and set port [{to|=}] port
[and node set host [{to|=}] host and set port [{to|=}] port] ...

To alter information properties:

alter connection connection_name
with properties
set property_name [{to|=}] property_value
[and set property_name [{to|=}] property_value ]…]

To drop information about properties:

alter connection connection_name
with properties drop property_name | ALL

Parameters

connection_name – the name of the connection to be altered.
agent_name – the name of the agent that establishes the connection to the database.
database_name – the name of the target database.
host – the host name of the machine on which the target database is installed.
port – the port number of the machine on which the target database is installed.
user – the login name of the Replication Server Data Assurance Option administrator.
password – the password for the administrator user login name.
description – description of the agent. Use double quotes if you are using a reserved word or blank spaces.
property_name – the connection properties for the Sybase JDBC driver, jConnect™ for JDBC™, which establishes the connection to the database.
See jConnect for JDBC 7.0 > jConnect for JDBC 7.0 Programmers Reference > Programming Information > Establishing a Connection > Connection Properties.
property_value – specifies the value of the property to be set.

Examples

Example 1 – resets the user name and password for connection “MyConnPDB”:

alter connection MyConnPDB 
set user=myuser2
and set password=mypwd2
go

The returned result is:

Connection “MyConnPDB” was altered successfully