Execute SQL Statement
Used to execute an SQL statement using an ODBC Data Source. e.g. INSERT, UPDATE.
For SELECT, use the Execute SQL Select step.
Inputs
| 1. | SQL Statement | (Mandatory) | The SQL statement that will be executed against the database |
| 2. | Data Source Name | (Mandatory) | The name of a system DSN configured on the machine where Scripter Server is hosted |
| 3. | Data Source User | (Optional) | The user name for the DSN |
| 4. | Data Source Password | (Optional) | The password for the DSN |
Fig. 1 - Execute SQL Statement - Inputs
Outputs
| 1. | Rows | The number of rows returned after executing the statement |
| 2. | Error Status | Use for diagnostic purposes only. If executing the SQL Statement generated an error, this Output contains the error reported by the database interface |
Fig. 2 - Execute SQL Statement - Outputs
Outcomes
| 1. | Fail | An error was returned from Softdial CallGem™ |
| 2. | Success | The query was successful |
Fig. 3 - Execute SQL Statement - Outcomes