The conn_properties table stores all connection configuration parameter values for all ASE Replicator database connections.
See “Connection configuration parameters” for information about connection configuration parameters.
Table A-5 lists the columns in the conn_properties table.
Column name |
Datatype |
Description |
|---|---|---|
conn_id |
numeric(18,0) |
Connection ID |
property |
varchar(128) |
Name of connection configuration parameter |
value |
varchar(255) |
Value of connection configuration parameter |
Each row in the conn_properties table identifies the value of a single connection configuration parameter for a specific database connection.
When you create a primary or replicate database connection, a row is added to the conn_properties table for each configuration parameter for the new connection.
When you set or change the value of a connection configuration parameter, the row that identifies the value of the specified configuration parameter for the specified database connection is updated.
When you delete a primary or replicate database connection, a row is deleted from the conn_properties table for each configuration parameter for the deleted connection.
