Dynamic Input In-DB Tool
Use Dynamic Input In-DB to take In-DB Connection Name and Query fields from a standard data stream and input them back into an In-DB data stream. The In-DB Connection Name and Query fields can be obtained from the Dynamic Output In-DB tool.
In-Database enables blending and analysis against large sets of data without moving the data out of a database and can provide significant performance improvements over traditional analysis methods. For more about the In-Database tool category, visit In-Database Overview.
Configure the Tool
- Connection Name Field: The alias for the In-DB connection to the database.
- Query / Query Alias List Field: The In-DB query created at this point in the workflow.
If the query fed into the Dynamic Input In-DB tool contains a WITH clause, this error is returned:
The In-DB Dynamic Input tool cannot accept a query which uses a WITH clause. Consider using a Query Alias List instead.
To resolve the error, modify the query to remove the common table expression (WITH clause).