type_id = T_TT_ID, symbol = T_S_SYMB, trade_qty = T_QTY, charge = T_CHRG, is_lifo = T_LIFO, trade_is_cash = T_IS_CASH from TRADE where T_ID = trade_id num_found = row_count select type_name = TT_NAME, type_is_sell = TT_IS_SELL, type_is_market = TT_IS_MRKT from TRADE_TYPE where TT_ID = type_id select hs_qty = HS_QTY from HOLDING_SUMMARY HS_CA_ID = acct_id and HS_S_SYMB = symbol if (hs_qty is NULL) then // no prior holdings exist hs_qty = 0 } Trade-Result Transaction Frame 2 of 7 The second Frame is responsible for modifying the customer's holdings to reflect the result of a buy or a sell trade. The database access methods used in Frame 2 are a mixture of References, Modifies, Removes and Adds. The VGenTxnHarness controls the execution of 2 as follows:
type_id = T_TT_ID, symbol = T_S_SYMB, trade_qty = T_QTY, charge = T_CHRG, is_lifo = T_LIFO, trade_is_cash = T_IS_CASH from TRADE where T_ID = trade_id num_found = row_count select type_name = TT_NAME, type_is_sell = TT_IS_SELL, type_is_market = TT_IS_MRKT from TRADE_TYPE where TT_ID = type_id select hs_qty = HS_QTY from HOLDING_SUMMARY HS_CA_ID = acct_id and HS_S_SYMB = symbol if (hs_qty is NULL) then // no prior holdings exist hs_qty = 0 } Trade-Result Transaction Frame 2 of 7 The second Frame is responsible for modifying the customer's holdings to reflect the result of a buy or a sell trade. The database access methods used in Frame 2 are a mixture of References, Modifies, Removes and Adds. The VGenTxnHarness controls the execution of 2 as follows:
tpcx-v_v2.1.0.docx