Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
((String)globalMap.get("tForeach_1_CURRENT_VALUE"))
"CREATE TEMPORARY TABLE temp_security_id
AS SELECT DISTINCT security_id FROM trade_import
WHERE client_trade_import_id = " + context.clientTradeImportId +
" DELETE FROM trade_import
WHERE client_trade_import_id = " + context.clientTradeImportId +
" DELETE FROM security
WHERE id IN (SELECT security_id FROM temp_security_id)
DROP TABLE temp_security_id"
"
BEGIN
CREATE TEMPORARY TABLE temp_security_id
AS SELECT DISTINCT security_id FROM trade_import
WHERE client_trade_import_id = " + context.clientTradeImportId + ";
DELETE FROM trade_import
WHERE client_trade_import_id = " + context.clientTradeImportId + ";
DELETE FROM security
WHERE id IN (SELECT security_id FROM temp_security_id);
DROP TABLE temp_security_id;
END;"
((String)globalMap.get("tForeach_1_CURRENT_VALUE"))