Advanced options

The section lists the additional capabilities for Database operations.

Parameter Description
Select Distinct Select the toggle to suppress the duplicate rows in the query output.
Note: This option is applicable only for Select operation.
Convert selected to String

Select the toggle to convert the fields with input or output data type to java.lang.String. The selected fields are automatically converted to a String data type. It does not impact the fields, which cannot be converted to String data type.

Note: This option is applicable for Select, Insert, Update, Delete, Batch Insert, and Batch Update operations.
Use SQL Expression (Advanced)
Use the following formats to provide SQL expressions -
  • For table columns, use tableAlias.columnName.
  • For valid database functions, use databaseFunction(tableAlias.columnName).For example, upper(tableAlias.columnName).
Note: This option is applicable for Select, Update, Delete, and Batch Update operations.