Previous Topic: Update in Database OperatorNext Topic: Output Parameters


Input Parameters

Input Source

Specifies that the user can choose to submit an 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.

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.