To add a database for a non-ASE data server, use the create connection command with a connection profile specific to your non-ASE data server. To add a database for an Adaptive Server data server, you use SAP Control Center or rs_init, both of which prepare the database for replication.
You can also use create connection for Adaptive Server data servers.
If you use create connection without a connection profile, you must prepare the database for replication yourself.
create connection to data_server.database
using profile connection_profile;version
set username [to] user
[set error class [to] error_class]
[set function string class [to] function_class]
[set password [to] passwd]
[set database_param [to] 'value']
[set security_param [to] {‘required’ | ‘not_required’}]
[with {log transfer on, dsi_suspended}]
[as active for logical_ds.logical_db |
as standby for logical_ds.logical_db]
[use dump marker]
[display_only]
You must use the with dsi_suspended clause, which starts the connection with the DSI suspended, when you create a connection to a database that will not be a replicate database.
The as active, as standby, and use dump marker clauses are used only when you create physical connections for a logical connection for a warm standby database. Only Adaptive Server and Oracle databases may be used in warm standby applications.
If your system supports network-based security, use the set security_param command.