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>"