Man illustrationFlower illustration

Docy

Execute update

Estimated reading: 2 minutes 76 views

Execute update activity executes a requested query on the database and returns the query result.


*Connection
name
The connection name defined to be used as the database connection variable.
Param1The value to be assigned to the first parameter.
Param2The value to be assigned to the second parameter.
Param3The value to be assigned to the third parameter.
Param4The value to be assigned to the fourth parameter.
Param5The value to be assigned to the fifth parameter.
ParametersUse this if you want to put multiple parameters.
*Query sqlValue of query sql.
*Result dataset nameReference name of dataset which will be created.
Note: * Fields selected with are required, others are optional.

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

robustaConnection

You can use the Param1 as shown in the example.

[‘1’, ‘STRING’, ‘in’, ‘2314589’]

You can use the Param2 as shown in the example.

[‘2’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param3 as shown in the example.

[‘3’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param4 as shown in the example.

[‘4’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Param5 as shown in the example.

[‘5’, ‘STRING’, ‘in’, ‘${companyName}’]

You can use the Parameters as shown in the example.

[[‘1’, ‘STRING’, ‘in’, ‘2314589’], [‘2’, ‘STRING’, ‘in’, ‘${companyName}’]]

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

insert into rpa_turkey_tablo2 (Ad,Soyad,Sirket_Adi,Unvan) values(‘:1′,’:2′,’:3′,’:4′);

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

employeesDataset
CONTENTS