My idea is that the Software Factory reads from a certain file path, looking for the SQL file and then attaching it to the 'Execute source code' step, but if there's another/better way I would love to hear it.
(It is not an option to generate the code inside the application where I would like the script to be run on)
Best answer by Anne Buit
You can create a new control procedure in the code group MANUAL. You might have to remove a prefilter from the code groups in the look-up to be able to select it.
The template of this control procedure should contain the code you need to run. This template can be assigned to a program object, also called manual.
This will cause a new code file to appear in the source code execution screen, at the bottom, called (coincidentally) manual.
This method will not read a file from disk, and instead will require you to put the code to be executed in a template. Will this suffice?