iVend Database Database : ReplicationUpdateSentStatus Stored Procedure

Creation Date

4/13/2015 12:00 PM

Encrypted

Ansi Nulls

Parameter

Direction

Description

Data Type

Size

@SentToSiteID

In

Records send to the site.

Integer

4

@LastSequenceNo

In

Records sent upto this sequence no.

BigInt

8

@BackupSequenceNo

In

Backup Sequence number

BigInt

8

@RETURN_VALUE

Return Value

Integer

4

Database Object

Object Type

Description

Dep Level

RepReplicationSendStatus

Table

Stores the replication data status sent between stores

1

CREATE PROCEDURE [dbo].[ReplicationUpdateSentStatus]

@SentToSiteID INT,

@LastSequenceNo BIGINT,

@BackupSequenceNo BIGINT

AS

BEGIN

IF(NOT EXISTS(SELECT SentToSiteID FROM RepReplicationSendStatus WHERE SentToSiteID = @SentToSiteID))

BEGIN

INSERT INTO RepReplicationSendStatus(SentToSiteID, LastSequenceNo, BackupSequenceNo) VALUES(@SentToSiteID, @LastSequenceNo, @BackupSequenceNo)

END

ELSE

BEGIN

--IF @LastSequenceNo <=0

-- RETURN

UPDATE RepReplicationSendStatus

SET SentToSiteID = @SentToSiteID, LastSequenceNo = @LastSequenceNo, BackupSequenceNo = @BackupSequenceNo

WHERE SentToSiteID = @SentToSiteID

END

END