Softdial Scripter™ - Step Library

Data Query

Used to execute a database query using SQL.

Inputs

1.	Query Text	(Mandatory)	The SQL query that will be executed against the database
2.	Generates Resultset	(Mandatory)	Select Yes to retrieve the results of the query. Generally, select Yes for SELECT queries No, for INSERT, UPDATE and DELETE queries
3.	Row Limit	(Optional)	The maximum number of rows to return if a Resultset is required. Default value is 25
4.	Time Out	(Optional)	The number of seconds to allow for the query before failing this step for taking too long. Default value is 5 seconds
5.	Lookup Timeout	(Optional)	The number of seconds to run the query for before timing out. Defaults to 5 seconds

Fig. 1 - Data Query - Inputs

Outputs

1.	Result Set	The results of the query if Input Generates Resultset is set to Yes. The data will contain at most the number of rows specified in the Row Limit Input
2.	Result Rows	If Input Generates Resultset is set to Yes, this contains the number of rows in the result set. Otherwise it contains the number of rows affected
3.	Error status	Use for diagnostic purposes only. If executing the query generated an error, this Output contains the error reported by the database interface

Fig. 2 - Data Query - Outputs

Outcomes

1.	Next	The query was successful
2.	Fail	An error was returned from Softdial CallGem™

Fig. 3 - Data Query - Outcomes