SQL Remote User's Guide
System Objects for Adaptive Server Anywhere
SQL Remote system views
Lists information about remote users and their status.
| Column | Description |
|---|---|
| user_name | The user ID of the user with REMOTE permissions. |
| consolidate | The column contains either an N to indicate a user with REMOTE permissions, or a Y to indicate a user with CONSOLIDATE permissions. |
| type_name | The name of the message type used to send messages to this user. |
| address | The address to which SQL Remote messages are to be sent. The address must be appropriate for the address_type. |
| frequency | How frequently SQL Remote messages are to be sent. |
| send_time | The next time messages are to be sent to this user. |
| next_send | The next time messages are to be sent to this user, in a more comprehensible format. |
| log_send | Messages are sent only to subscribers for whom log_send is greater than log_sent. |
| time_sent | The time the most recent message was sent to this subscriber. |
| log_sent | The transaction log offset for the most recently sent operation. |
| confirm_sent | The transaction log offset for the most recently confirmed operation from this subscriber. |
| send_count | How many SQL Remote messages have been sent. |
| resend_count | Counter to ensure messages are applied only once at the subscriber database. |
| time_received | The time the most recent message was received from this subscriber. |
| log_received | The log offset in the subscriber's database for the operation most recently received at the current database. |
| confirm_received | The log offset in the subscriber's database for the most recent operation for which a confirmation message has been sent. |
| receive_count | How many messages have been received. |
| rereceive_count | Counter to ensure messages are applied only once at the current database. |