Can I read in an external sql file and use this in a query
Hello,
I would like to use an external text file as the source for a database query to be executed.
Background:
I would like to develop, test, etc. my sql scripts in a dedicated tool (eg. Toad) and then save that SQL file to a certain disk location so it can be used in a Knime workflow. Reason that I don't want to copy/paste it into the workflow is that some customer selections are made in this sql script and this script is also used by other people/scripts.
I am afraid to have multiple versions of the customer selection script flying around...
Regards,
Geoffrey