Example: Call to the Rules Engine with variables

Previous Next

Here is an example of a PowerShell script which uses the $USEngine object to execute a database query and passes variables to the SQL statement:

INVOKE USPowershell.ExecuteScript

WITH

SELECT 'Write-Output $USEngine.ExecuteSQLQuery("select table_name || :1, :2 from t_table ", "_TST", 12345)  '

This results in:

TABLE_SEQUENCE_NUMBERS_TST        12345

T_APP_TIME_TST        12345

T_EVENT_TST        12345

 

See also

Example: Simple script execution

Example: Script execution with parameters

Example: Stateful test

Example: Dynamically Adding C#

Example: Converting Word to PDF

Example: Query call to the Rules Engine

Example: Manipulation call to the Rules Engine

Example: Query call to the Rules Engine and loop through result

USPowerShell