The SQL transformers allow you to hardcode your SQL in the interface or select it from an attribute constructed earlier in the process. It would also be nice to be able to run SQL "from file" where the code is stored externally in a *.sql file. This could be a little like the flexibility offered in the FTPCaller "upload from a file" or "upload from an attribute".
Archived
SQL Transformer - read SQL from file
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+23- Enthusiast
Hi 1spatialdave,
I've made my own custom transformer and published this on the FME HUB. It is called SQLStatementFilter.
It basically accepts an .sql-file and omits blank spaces, omits comments and concatenates all lines to return one sql-statement.
This statement can than be used inside an SQLExecutor transformer.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.