Sybase SQL remote Change the way to transfer a breakpoint

Transmission of data between Sybase's ASA and ASE databases through SQL remote often encounters errors in the transmission log point.

First, through the translation of the log, and against the ASA, ASE Transmission log, determine the correct ASA send point

1, in ASA through Sa_setremoteuser stored procedures, change the Sysremoteuser table Log_sent, confirm_sent fields, other fields to retain the original values in the Sysremoteuser table

2, the following is the Sa_setremoteuser function and its parameters:

Sa_setremoteuser (p_user_id unsigned integer,p_log_sent numeric (), p_confirm_sent Numeric (), P_send_count Integer, P_resend_count integer,p_log_received Numeric (m), p_confirm_received Numeric (m), P_receive_count Integer,p_ Rereceive_count integer)

3, the Sa_setremoteuser parameter and table Sysremoteuser field value correspondence relation

Parameter fields

p_user_id user_id

P_log_sent log_sent

P_confirm_sent confirm_sent

P_send_count Send_count

P_resend_count Resend_count

P_log_received log_received

P_confirm_received confirm_received

P_receive_count Receive_count

P_rereceive_count Rereceive_count

4, ASA Sysremoteuser table and ASE Sr_remoteuser table of the corresponding relationship, but some of the values on either side of the field will not be exactly the same, for example: there can be ASA in the data transfer, but ASE has not done data transmission, at this time ASA Log_ Sent may be greater than ASE's log_received

ASA Sysremoteuser ASE Sr_remoteuser

Log_sent log_received

Confirm_sent confirm_received

Send_count Receive_count

Resend_count Rereceive_count

Log_received log_sent

Confirm_received confirm_sent

Receive_count Send_count

Rereceive_count Resend_count