Executing SQL in Cycle

With an established JDBC connection, you can execute SQL commands from within a Feature File. Use SQL to create or 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>"