Any row in the syssyncresult system table contains information about the most recent synchronization.
| Column name | Column type | Description |
|---|---|---|
| sql_code | INTEGER | The SQL code from the last synchronization. |
| error_string | CHAR(200) | The error message from the last synchronization. |
| stream_error_code | SMALLINT | The specific stream error. See the ss_error_code enumeration for possible values. |
| system_error_code | INTEGER | A system-specific error code. For more information about error codes, see your platform documentation. |
| stream_error_string | CHAR(80) | A string with additional information, if available, for the stream_error_code value. |
| upload_ok | BIT | True if the upload was successful; false otherwise. |
| ignored_rows | BIT | True if uploaded rows were ignored; false otherwise. |
| auth_status | UNSIGNED SMALLINT | The synchronization authentication status. |
| auth_value | INTEGER | The value used by the MobiLink server to determine the auth_status result. |
| auth_info | CHAR(1024) | The authentication message returned from the MobiLink user authentication script. |
| partial_download_retained | BIT | The value that tells you whether a partial download was retained. |
| timestamp | TIMESTAMP | The time and date of the last synchronization. |
| sent_bytes | UNSIGNED INT | The number of bytes currently sent for the upload. |
| sent_inserts | UNSIGNED INT | The number of rows currently inserted for the upload. |
| sent_updates | UNSIGNED INT | The number of updated rows currently sent for the upload. |
| sent_deletes | UNSIGNED INT | The number of deleted rows currently sent for the upload. |
| received_bytes | UNSIGNED INT | The number of bytes currently sent for the download. |
| received_inserts | UNSIGNED INT | The number of rows currently inserted for the download. |
| received_updates | UNSIGNED INT | The number of updated rows currently sent for the download. |
| received_ignored_updates | UNSIGNED INT | The number of duplicate rows that were received in the download. |
| received_deletes | UNSIGNED INT | The number of deleted rows currently sent for the download. |
| received_ignored_deletes | UNSIGNED INT | The number of deleted rows that were received in the download of rows that have already been deleted. |
| received_truncate_deletes | UNSIGNED INT | The number of rows that were deleted in the download by a truncate operation. |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |