Databases › Select from Database Operator › Input Parameters

Input Parameters

Input Source

Specifies that the user can choose to submit SQL statement as an in-line expression (the default) or data variable. Select either Inline Text or Expression from the drop-down list.

Inline text

Only available when Inline Text is selected as the Input Source. Specifies the generic SQL statement as inline text. Click the Inline Text field to open the Inline Text editor, where you can enter a literal SQL statement.

Expression

Only available when Expression is selected as the Input Source. Specifies the generic SQL statement as an expression. Use this field to provide a variable.

Maximum rows to retrieve

Specifies the maximum number of rows to be retrieved by the select statement. This parameter overrides the property set at the operator category level.

Input parameters

An array of input values. If the generic SQL statement specified uses JDBC escape syntax and requires input parameters, they can be specified here.

Display null values

If checked, the Generic SQL Operator results contain the field NullFieldFlags. If the generic SQL statement returns results sets, this field can be used to distinguish null values from default values.

For example, querying an integer column that contains a null value returns 0. The NullFieldFlags value for this column is true. However, if the table actually stored the value 0, then the NullFieldFlags value are false.