Execute SQL Select
Used to execute an SQL SELECT statement using an ODBC Data Source.
Inputs
| 1. | SELECT Statement | (Mandatory) | The SQL SELECT statement that will be executed against the database |
| 2. | Row Limit | (Optional) | The maximum number of rows to return if a Resultset is required. Default value is 25 |
| 3. | Data Source Name | (Mandatory) | The name of a system DSN configured on the machine where Scripter Server is hosted |
| 4. | Data Source User | (Optional) | The user name for the DSN |
| 5. | Data Source Password | (Optional) | The password for the DSN |
Fig. 1 - Execute SQL Select - Inputs
Outputs
| 1. | Rows | (Optional) | The number of rows returned after executing the statement |
| 2. | Result | (Mandatory) | The result returned from the statement |
| 3. | Error Status | (Optional) | Use for diagnostic purposes only. If executing the SELECT statement generated an error, this Output contains the error reported by the database interface |
Fig. 2 - Execute SQL Select - Outputs
Outcomes
| 1. | Fail | An error was returned from Softdial CallGem™ |
| 2. | Success | The SELECT statement was executed successfully |
Fig. 3 - Execute SQL Select - Outcomes