DB Get Step

Use the DB Get step to assign to specific variables the results of the Structured Query Language (SQL) query that you define in the DB Read step.

Note

Before you can use a DB Get step, you must use a DB Read step to define the SQL statements and identify the target database.

Each time the script executes the DB Get step, the script retrieves one row of the results returned by the DB Read step and places them in the variables you assign. To move to the next row in a table, you must execute the DB Get step again.

The DB Get step has three output branches:

  • Successful—The DB Get step successfully retrieved data.

  • No Data—The DB Get step did not retrieve data.

  • SQL Error—There was an error in the SQL command.

Note

You cannot create Join queries that retrieve columns with the same name from different tables. (For example, you cannot create “select a.x, b.x from a,b” and “select a.x as y from a”.) Similarly, you cannot make aliases of column names. The SQL statements SELECT count(*) and SELECT min(*) are not supported.

The DB Get customizer window contains two tabs:

  • General (DB Get Step)

  • Field Selection (DB Get Step)