DI DB Expert Module

Use the DI DB Expert module to handle your database statements through a single module. This module offers the same basic functionality as the DB Expert module, along with the option to use one of your Data Integrity connections for your tests.

This module contains the following values:

Value	Description
Connection	Specify the DI connection you want to use for your test. To do so, click into the Value field and select a connection from the drop-down menu. Note that you can't override the specified connection with dynamic text expressions such as buffers or test case parameters.
SQL Statement	SQL statement you want to execute.
Result Table	Verify or buffer values from the result of your SQL statement. For more information on table steering, see chapter "Table". If needed, you can buffer or verify the table property RowsAffected. This property indicates how many rows the specified SQL statement affected. If the statement didn't affect any rows, the value is 0. For SELECT statements, the value is -1. Alternatively, if you want to export the result of your SQL Statement into a comma separated CSV file: Enter {EXPORTTOCSV[<absolute path to the CSV file>]} as the value of Result Table. Use action mode Insert or Select. If the file doesn't exist at runtime, Tosca Cloud creates it. If a file with the same name already exists under this path, Tosca Cloud overwrites the existing file.
Close Connection	The default value True closes the connection after executing the SQL statement. If you want to keep the connection open, change the value to False.