create connection using profile

create connection using profile clause uses predefined information to configure the connection between Replication Server and a non-Adaptive Server database, and, if needed, to modify the RSSD and the named data_server.database. To create a connection to Adaptive Server, see create connection.

Syntax

create connection to data_server.database
using profile connection_profile;version
set username [to] user 
[other_create_connection_options]
[display_only]

Parameters

Examples

Usage

  • Connection profiles specify the function-string class and the error class. Connection profiles can also specify other connection options such as whether commands should be batched and what command separator to use. In addition to connection settings, connection profiles can specify class-level translations to install in the RSSD and objects, such as the rs_lastcommit table, to be created in the replicate database.

  • When you create a connection using a connection profile, the system table services (STS) caches are refreshed so that you do not need to restart Replication Server.

  • Always specify the set username clause right after the using profile clause.

Related reference
admin show_connection_profiles
create connection