In batch mode, multiple records can be loaded into the database by one EagleML message. The warehouseTransaction element should contain several warehouseBrokerTradeQuote complex elements when loaded in this mode. Data from each of the elements will be loaded into a separate database row.
Batch Key Element
When loaded in batch mode, the warehouseBrokerTradeQuote complex elements should contain the same Master Ticket Number element. The Master Ticket Number value should also be specified in the warehouseTransaction/batchKey element.
Example of a valid Batch Key:
| Code Block | ||
|---|---|---|
| ||
<batchKey>1200303M</batchKey> |
Insert/Update Details
The stored procedure for batch mode supports only inserting data into the database.
| Info | ||
|---|---|---|
| ||
| UPSERT mode is NOT supported for Warehouse Broker Trade Quote. |