SQL Remote User's Guide
System Objects for Adaptive Server Enterprise
SQL Remote system tables
Each row describes a user ID with REMOTE permissions (a subscriber), together with the status of SQL Remote messages sent to and from that user.
| Column | Data type | Description |
|---|---|---|
| user_id | INT | The user ID of the user with REMOTE permissions. |
| consolidate | CHAR(1) | The column contains either an N to indicate a user granted REMOTE permissions, or a Y to indicate a user granted CONSOLIDATE permissions. |
| type_id | INT | The ID of the message system used to send messages to this user. |
| address | VARCHAR(128) | The address to which SQL Remote messages are to be sent. The address must be appropriate for the address_type. |
| frequency | CHAR(1) | How frequently SQL Remote messages are to be sent. |
| send_time | DATETIME | The next time messages are to be sent to this user. |
| log_send | NUMERIC(20, 0) | Messages are sent only to subscribers for whom log_send is greater than log_sent. |
| time_sent | DATETIME | The time the most recent message was sent to this subscriber. |
| log_sent | NUMERIC(20, 0) | The log offset for the most recently sent operation. |
| confirm_sent | NUMERIC(20, 0) | The log offset for the most recently confirmed operation from this subscriber. |
| send_count | INT | How many SQL Remote messages have been sent. |
| resend_count | INT | Counter to ensure messages are applied only once at the subscriber database. |
| time_received | DATETIME | The time the most recent message was received from this subscriber. |
| log_received | NUMERIC(20, 0) | The log offset in the subscriber's database for the operation most recently received at the current database. |
| confirm_received | NUMERIC(20, 0) | The log offset in the subscriber's database for the most recent operation for which a confirmation message has been sent. |
| receive_count | INT | How many messages have been received from this subscriber. |
| rereceive_count | INT | Counter to ensure messages are applied only once at the current database. |
| filler1 | CHAR(255) | Reserved |
| filler2 | CHAR(255) | Reserved |
| filler3 | CHAR(255) | Reserved |
| filler4 | CHAR(255) | Reserved |