Execute query

Execute query activity is used for adding, updating and deleting records in the database.


* Connection name	The defined connection name before is chosen from the dropdown.
Param1	The value to be assigned to the first parameter is written.
Param2	The value to be assigned to the second parameter is written.
Param3	The value to be assigned to the third parameter is written.
Param4	The value to be assigned to the fourth parameter is written.
Param5	The value to be assigned to the fifth parameter is written.
Parameters	If it is desired to put multiple parameters, parameters are written.
*Query sql	The value of sql query is written.
*Result dataset name	The reference name is given to the dataset which will create in this field.

Note: * Fields selected with are required, others are optional.

Connection name example

You can use the Connection name as shown in the example.

robustaConnection

Param1 examples

You can use the Param1 as shown in the examples.

2314589

${customerID}

Param2 examples

You can use the Param2 as shown in the examples.

Company A

${companyName}

Param3 examples

You can use the Param3 as shown in the examples.

area

${area}

Param4 examples

You can use the Param4 as shown in the examples.

title

${title}

Param5 examples

You can use the Param5 as shown in the examples.

robusta

${company}

Parameters example

You can use the Parameters as shown in the example.

[2314589, Company A]

[${customerID}, ${companyName}]

Query sql example

You can use the Query sql as shown in the example.

SELECT * FROM db_test.customer_infos WHERE CustomerID = ‘:1’ AND CompanyName = ‘:2’ ;

Result dataset name example

You can use the Query sql as shown in the example.

employeesDataset