The Trade ID for the pending trade that has triggered and needs to be to be trigger_id IN submitted to the MEE. Trade ID is the primary key of the TRADE table. bid_price OUT Requested bid/ask price for triggered limit trade. num_found OUT Number of rows found to trigger. status OUT Code indicating the execution status for this frame. symbol OUT Security symbol for triggered limit trade. trade_id OUT Trade ID of triggered limit trade. trade_qty OUT Requested share quantity. trade_type_id OUT type of triggered limit trade. Trade-Result_Frame-7 Pseudo-code: Submit the triggered limit trade { declare now_dts DATETIME start transaction get_current_dts(now_dts) select TR_T_ID, TR_BID_PRICE, TR_S_SYMB, TR_TT_ID, TR_QTY from TRADE_REQUEST where TR_T_ID = trigger_id num_found = row_count delete TRADE_REQUEST TR_T_ID = trigger_id update TRADE set T_DTS = now_dts, T_ST_ID = status_submitted where T_ID = trigger_id insert TRADE_HISTORY (TH_T_ID, TH_DTS, TH_ST_ID) values (trigger_id, now_dts, status_submitted)
trigger_id IN The Trade ID for the pending trade that has triggered and needs to be to be submitted to the MEE. Trade ID is the primary key of the TRADE table. bid_price OUT Requested bid/ask price for triggered limit trade. num_found OUT Number of rows found to trigger. status OUT Code indicating the execution status for this frame. symbol OUT Security symbol for triggered limit trade. trade_id OUT Trade ID of triggered limit trade. trade_qty OUT Requested share quantity. trade_type_id OUT type of triggered limit trade. Trade-Result_Frame-7 Pseudo-code: Submit the triggered limit trade { declare now_dts DATETIME start transaction get_current_dts(now_dts) select TR_T_ID, TR_BID_PRICE, TR_S_SYMB, TR_TT_ID, TR_QTY from TRADE_REQUEST where TR_T_ID = trigger_id num_found = row_count delete TRADE_REQUEST TR_T_ID = trigger_id update TRADE set T_DTS = now_dts, T_ST_ID = status_submitted where T_ID = trigger_id insert TRADE_HISTORY (TH_T_ID, TH_DTS, TH_ST_ID) values (trigger_id, now_dts, status_submitted)
tpcx-v_v2.1.0.docx