Configuring a Subscriber Replying Sender

A Subscriber endpoint can be configured to send the subscription status as a reply to the message sender if the message contains a reply subject. The ADB_SUBSCRIBER_STATUS AE schema is used for this reply message.

The following table lists and describes the fields in the ADB_SUBSCRIBER_STATUS AE schema.

Field	Type	Description
RETURN_CODE	i4	return_code=0, when the data is inserted into the destination table successfully. return_code=-1, when the data is inserted into the exception table. return_code=5, when the data fails to be inserted in both destination and exception tables. If you specify a subscriber precommit stored procedure, this field will contain the value of the `RETURN_CODE` output parameter.
ADB_TEXT	string	Contains the status or error message of the subscriber operation.
NUMBER_OF_UPDATED_ROW	i4	Indicates the number of records that have been updated when you run the SQL update statement. This field helps you track the current behavior of Subscription Service. Note: The following situations affect the value of this field: When Subscription Service receives a group message, the value of the NUMBER_OF_UPDATED_ROW field is the sum of the messages updated in the database. When Subscription Service receives a parent-child message, the value of the NUMBER_OF_UPDATED_ROW field is the number of rows of the parent table that are updated in the database. The NUMBER_OF_UPDATED_ROW field does not support bulk insert operations. For more information, see Adding NUMBER_OF_UPDATED_ROW After Migration.
CALLOUT_TEXT	string	Contains an error message from the database driver in case of an error operation. If you specify the subscriber precommit stored procedure, this field will contain the value of the `SP_TEXT` output parameter.