SQL Extract (deprecated)

This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation .

This node extracts the SQL query from a database port and creates a flow variable and data table containing the query.

Input ports

1. Type: Database Query
   Database Port
   A database port with a connection and a query

Output ports

1. Type: Flow Variable
   SQL query flow variable
   The SQL query as a flow variable
2. Type: Table
   SQL query table
   The SQL query as a string cell in a table with 1 row and 1 column.