Used in the LOAD MODULE statement to provide the bindings for the parameter inside the module at load time.
PARAMETERS parameter1-inModule = value-parentScope [,...]
parameter1-inModule | The name of the parameter defined in the module. |
value-parentScope | The value in the parent scope being bound to. This value can be an expression or another parameter defined in the parent scope. |
You cannot directly bind a parameter defined within a module at runtime; doing so generates a server warning. You can bind module parameters using only the LOAD MODULE statement.
This example maps the parameters in the module to another value (minValue=2) and to another parameter (maxValue=serverMaxValue).
CREATE MODULE filterModule IN filterIn OUT filterOut BEGIN CREATE SCHEMA filterSchema (Value Integer); DECLARE PARAMETER Integer minValue := 4; PARAMETER Integer maxValue; END; CREATE INPUT STREAM filterIn SCHEMA filterSchema; CREATE OUTPUT STREAM filterOut SCHEMA filterSchema AS SELECT * FROM filterIn WHERE filterIn.Value > minValue and filterIn.Value < maxValue; END; DECLARE PARAMETER Integer serverMaxValue; END; LOAD MODULE filterModule AS filter1 IN filterIn=marketIn OUT filterOut=marketOut PARAMETERS minValue=2, maxValue=serverMaxValue;