Verifying Db2 Data

Data in Db2 can be extracted into a test scenario by using the SQL Select element. Then it is possible to verify if data is as expected by using a Verify element where an expression can evaluate the data or by saving the complete execution result for future validation. The example below checks the the column value for FIRSTNAME is not empty for any rows.

The feature to record execution output as future validation can also be used for saving row/columns values from SQL Select and compare these data with future values.