Executing SQL in Cycle

With an established JDBC connection, executing SQL commands from within a Feature File is simple. Use SQL to create/load data, validate test results, retrieve variables for use in the Feature File, and more.

Inline SQL Statements

To run a SQL statement inline in Cycle, use the following Step:

I execute SQL "select lodnum from invlod"

SQL Scripts

To have Cycle run a SQL script from a file, use the Step:

I execute SQL script "<SQL_FILE_PATH>"