I need to run a sql statement to determine if my workspace should run. If the sql statement returns any records, then I need to terminate the flow. If nothing is returned then it is okay to run the workspace. I would like to pass in a user parameter as a string to be used in the sql statement. Is this possible?
Solved
Can you run a SQLExecutor transformer that takes a string as a parameter and uses it as part of the SQL statement to be executed?
+3- Participant
Best answer by redgeographics
In short: yes, you can build the query using attribute values, parameters etc.
You should probably look into the NoFeaturesTester to check if nothing comes back too
+49- Celebrity
- Best Answer
In short: yes, you can build the query using attribute values, parameters etc.
You should probably look into the NoFeaturesTester to check if nothing comes back too
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.