replaces a current database connection definition, which includes the agent and the JDBC parameters with a new connection definition.
replace connection connection_name
set type [{to|=}] {ASE | ASE_CLUSTER | RSSD | IQ | Oracle | HANADB}
and 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|=}] user
[and set password [{to|=}] password]
[and set desc [{to|=}] description]
[with node set host [{to|=}] host and set port [{to|=}] port
[and node set host [{to|=}] host
and set port [{to|=}] port]…]
[with properties set property_name [{to|=}] property_value
[and set property_name [{to|=}] property_value ]…]
ASE – for an Adaptive Server database connection.
ASE_CLUSTER– for an Adaptiver Server Cluster database connection.
RSSD – for a Replication Server System Database (RSSD) connection.
IQ – for a Sybase IQ database connection.
ORACLE– for an Oracle database connection.
HANADB – for an SAP HANA database connection.
You cannot set the host name and port number for an ASE_CLUSTER connection; you must set these values inside a node definition. agent_name is invalid, if the connection type is Replication Server System Database (RSSD). An RSSD connection cannot define an agent.
See jConnect for JDBC 7.0 > jConnect for JDBC 7.0 Programmers Reference > Programming Information > Establishing a Connection > Connection Properties.
replace connection prod1 set type = ASE set agent = localagent and set host = pluto and set port = 5050 and set database = prod1 and set user = prod_admin and set password = openSes4me with properties set ENCRYPT_PASSWORD = true and set PACKETSIZE = 1024 go