All Products
Search
Document Center

:Why does an update statement subscribe to multiple records when you use DTS to subscribe to data?

Last Updated:Jan 16, 2023

Overview

This article describes why multiple records are subscribed to during an update operation when DTS data subscription is used.

Description

The subscribed data is a log of each change operation of the source database in the Binlog file. For example, if an update statement updates three records, three update messages are recorded in the Binlog. Therefore, the subscribed data contains three update statements.

Application scope

  • Data Transmission Service (DTS)