Creating a Logical Connection

Create a logical connection, which establishes one symbolic name for both the active and standby databases.

In a warm standby application, the active database and the standby database appear in the replication system as a connection from the Replication Server to a single logical database. A logical connection is created to establish one symbolic name for both the active and standby databases. The names do not have to exist in the interfaces file nor in the replication system.

Log in to the Replication Server:
```
isql -Usa -P -SPRS
```
Create the logical connection for the warm standby:
```
create logical connection to pubs2a.pubs2s
go
```
Enable SQL statement replication:
```
alter logical connection to pubs2a.pubs2s
set ws_sqldml_replication to "on"
go
```
Note: SQL statement replication is only available in Adaptive Server 15.0.3 and later.
Exit the isql session.