Databases › Query 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 retrieve. If blank, the default value is 10 rows. The Generic SQL Operator retrieves a maximum of 512 rows. Additional rows will be truncated.

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 will 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 would be true. However, if the table actually stored the value 0, then the NullFieldFlags value would be false.