User Guide

Back Next

Parameter Element

The Parameter element allows you to specify the data mapped to placeholders ('?') in your query.

Field	Definition
Basic Tab
Parameter Index	The index number of this parameter. Counting begins with 1.
Data Type	The data type of this parameter. By default, the data type CHAR is used unless this parameter is mapped to a column in the Input RowSet, in which case, the data type will be determined from the Input. Default Value: CHAR
Value	Specify a value for this parameter. You can leave this blank if the Map From attribute was specified.
Map From	Specify the index or name of the column in the Input RowSet (if one was defined in the Query) that should be mapped to this parameter. Mapping means that the value from the specified column be taken as the value of this input parameter when executing the SQL Statement.
Null Substitute	Specify the value that should be used as a replacement for null values that are in the Input RowSet. This value is ignored if the specified SQL statement is a SELECT statement.