I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.
Solved
SQLExecutor - can a user parameter serve as the Initiator?
+10- Contributor
- 9 replies
Best answer by ebygomm
You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter
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.
+44- Influencer
- 3427 replies
- Best Answer
You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter
+10- Contributor
- 9 replies
You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter
Thanks, that did it.