Insert/Update/Delete action

Use the Insert/Update/Delete action in the Database package to execute an INSERT, UPDATE, or DELETE statement from the database.

Settings

  • In the Session name field, enter the name of the session that you used to connect to the database server in the Connect action.
  • In the Statement field, enter the SQL statement to insert, update, or delete the records.
    Note: When you use Excel as a database, the Insert/Update/Delete action is supported for ODBC connectivity. See the complete list of database supported servers in Automation 360.

    Database server support matrix

    • Use an INSERT statement to create new records in a table:
      INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...)
    • Use an UPDATE statement to modify a record:
      UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition
    • Use a DELETE statement to remove a record:
      DELETE FROM table_name WHERE condition
Example: DELETE FROM Persons WHERE LastName='Smith'
    Note: In order to modify and manipulate data in the database, you can use the data type mapping as mentioned in the Run procedure action. See Using the Run stored procedure action.
  • In the Timeout for the query in seconds field, specify the time within which the statement execution should stop, even if the execution is not completed.

    If you do not enter a value in the Timeout for the query in seconds field, then the default timeout specified in the driver library is used.