Run Query

This pre-built action, located under the @Generic element, instructs Avo Assure to execute the specified query on the database defined in the input value and stores the result in a dynamic variable.

Syntax

Input Value: <DB IP/instance name/DB file path>; <DB port>;<DB username>;<DB password>;<DB name>; <Query>;<DB Number>;<collection/ warehouse>(Optional);<querytype/ schema>(Optional)

Argument	Description
<DB IP/instance name/DB file path> (Required)	Specifies the database server location, instance identifier, or database file path
<DB port> (Required)	The port number used to connect to the database.
<DB username> (Required)	The username credential for database access.
<DB Password> (Required)	The password credential for database access.
<DB name> (Required)	Required name of the database to connect.
<Query> (Required)	Required SQL or Non SQL query to be executed.
<DB Number> (Required)	Database Number serves as a unique identifier for a specific database connection.
<collection/warehouse> (Optional)	Required the specific data container within the database to target.
<querytype/schema> (Optional)	Defines the nature of the query or specifies the database schema to be used.

Click below link to get more information about Supported Database in Avo Assure

Supported Technologies

Note: When using a Non-SQL Query to run a specific action, the user must provide either the collection name or the warehouse name in the input syntax.

Output Value:

Argument	Description
<Dynamic Variable> (Required)	This variable stores the outcome of the operation
<Dynamic Variable> (Optional)	This variable stores the status as True or False

Example:

Execute Database Query The Run Query(DB) action takes values from the Input Value column, including database connection details and a query. It connects to the specified database and executes the query provided. The result of the query is stores in {Outcome} Variable, while the execution status is saved in the {Status} variable with the following possible values:

• True – if the query runs successfully

• False – if the query execution fails