Solved

SQLExecutor - can a user parameter serve as the Initiator?


Badge +1

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.

icon

Best answer by ebygomm 27 July 2021, 17:44

View original

2 replies

Badge +10

You can just put a creator in front of your sqlexecutor, this will then execute the sql statement once, using your referenced parameter

Badge +1

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