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?
+3- Participant
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
+39- Influencer
- 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
1 person upvoted this
+3- Participant
ebygomm wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.