"GET_DB_VALUE" Command

Description: This command executes an SQL statement using a query or a statements using a file and assigns the values to variables.
Usage Scenario: Suppose we want to get the id, username, first name, last name and email address from the table by the name of users and then print them.

Procedure: Define your step with Get_DB_Value command and enter variable names for each of the fields. Set your DB Connection (You will need to edit the DB Connection to include your own database parameters: Username/Hostname/Vendor, etc) and use the query such as the below to retrieve the data. The print command will print the data.

Your step will look like this:

Open