2.10 - SQL Testing with Appvance

SQL Testing with AIQ

SQL Testing with AIQ Use SQL testing in AIQ when a scenario must validate database state, prepare...

How to Create a Valid SQL Script

To create a valid SQL script in Appvance AIQ, you must configure the database connection properti...

Setting up the Environment

Now let’s see how to create an SQL script using the required configuration settings. In this exam...

Creating a New Database Scenario

Once you have created a valid SQL script, you can create an AppVance Scenario to execute it using...

Reviewing SQL Test Execution Results

This section explains how to review the results of a SQL test execution and how to customize the ...

Sample SQL Scripts for AIQ Testing

Recommended guidance Sample SQL scripts should demonstrate safe, repeatable validation patterns f...

Reduce MySQL Results Database Storage Usage

Reduce MySQL Results Database Storage Usage Use this procedure when the AIQ results database is c...

SQL Testing Appendix for AIQ

Recommended guidance Use the SQL Testing appendix for supplemental reference material that suppor...