Receiving notifications from multiple tables within the ObjectServer
The gateway can receive details of updates, inserts,
and
deletes to multiple tables from the ObjectServer.
By default, the gateway writes all the updates to
the file, then all the inserts, and then all the deletes.
The alert data written to the output file has the following structure:
UPDATE: ...
UPDATE: ...
INSERT: ...
INSERT: ...
DELETE: ...The gateway can also write the details of the notifications from multiple tables to the output file with separators between the notifications from each table. To do this, set the Gate.File.BatchSeparator property to TRUE, and then specify the separators that the gateway adds to the start and to the end of each batch using the Gate.File.BatchHeader and Gate.File.BatchTrailer properties respectively. Using the default values for the batch separators, the alert data written to the output file has the following structure:
########## BATCH START ##########
Table:alerts.status
UPDATE: ...
UPDATE: ...
########## BATCH END ##########
########## BATCH START ##########
Table:alerts.status
INSERT: ...
INSERT: ...
########## BATCH END ##########
########## BATCH START ##########
Table:alerts.status
DELETE: ...
########## BATCH END ##########