Parameter Declaration

The example declares a parameter called ThresholdValue in the DECLARE block, for which it sets the default value 1000. You can change the default value at runtime, or in the project configuration file.

DECLARE
 PARAMETER INTEGER ThresholdValue := 1000;
end;

The example creates an input window named TradeWindow and an output window named TradeOutWindow. TradeOutWindow uses a SELECT statement to pull data from TradeOptMatch; a WHERE clause tells TradeOutWindow to output only data from TradeWindow where the product of TradeWindow.Volume is greater than the value set for the ThresholdValue parameter.

CREATE  OUTPUT  WINDOW TradeOutWindow
	SCHEMA (Ts BIGDATETIME, Symbol STRING, Price MONEY(2), Volume INTEGER)
	PRIMARY KEY (Ts)
AS
	SELECT * from TradeWindow WHERE TradeWindow.Volume > ThresholdValue;

The example attaches a File CSV Input adapter named csvConn1 to TradeWindow.