SQL Remote User's Guide
System Objects for Adaptive Server Anywhere
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 | UNSIGNED 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 | SMALLINT | The ID of the message system used to send messages to this user. |
| address | LONG VARCHAR | 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. P for Periodically, and A stands for Occasionally. |
| send_time | TIME | The next time messages are to be sent to this user. |
| log_send | NUMERIC(20, 0) | If log_send is greater than log_sent, the Message Agent resends messages immediately to the subscriber the next time it is run. |
| time_sent | TIMESTAMP | The time the most recent message was sent to this subscriber. |
| log_sent | NUMERIC(20, 0) | The local log offset for the most recently sent operation to this subscriber. |
| confirm_sent | NUMERIC(20, 0) | The log offset for the most recently confirmed operation from this subscriber. |
| send_count | INT | The number of SQL Remote messages have been sent to this subscriber. |
| 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 number of messages received from this subscriber. |
| rereceive_count | INT | Counter to ensure messages are applied only once at the current database. |