Use this action to execute a non-query SQL statement like create, update, delete etc.
|SQL||Non-query SQL statement to be executed. This action doesn’t return any result.|
Use this action to execute a SQL query statement. Only first record from result dataset is available for use.
|SQL||SQL query statement to be executed. First record data from result dataset is stored as per field mapping configurations under this action.|
Select field mapping action maps a variable with a column. Value as per the given column in first record of result dataset is stored in the respective variable.
|Field||It is name of a column in result dataset.|
|Variable||Variable to hold respective column value.|