This help page is for CXone Studio. This information is also available for Desktop Studio.

Submits a SQL (Structured Query Language) statement to a database server for the purposes of updating or inserting a record.

For more details on database servers, see the Sqlselect action.

Supported Script Types

A square with a line branching from it that goes to three other squares.


Email Chat Phone Voicemail Work Item SMS

Input Properties

These properties define data that the action uses when executing.



Add Caption

Enter a short phrase that uniquely identifies this action in the script. The caption appears on the script canvas under the action icon.

SQL Statement

The SQL Statement that will be submitted to the database server.

This statement should not return records.

Fetch Identity Variable

The name of a variable to receive the identity value from an insert.

This property is used only when the table you are inserting contains an identity column.

Timeout Sec

The number of seconds the action waits to execute before timing out. The value must be between 0 and 60.

Result Branch Conditions

Result branch conditions allow you to create branches in your script to handle different outcomes when an action executes.




Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the action's other branches are not defined.
OnError Path taken when the action fails to execute properly. For example, when there is an unexpected problem such as poor connectivity, syntax errors, and so on. The _ERR variable, with a single underscore character, should be populated with a condensed explanation of the problem.
OnTimeout Path taken if there is no response for the number of seconds specified.