Executing SQL Queries Dynamically
The EXECUTE SQLI command can be used to run SQL commands:
:FILENAME = '..\..\tmp\sqlfile.txt'; EXECUTE SQLI :FILENAME;
This command can be used to run both static (pre-written) or dynamic code.
Note that EXECUTE SQLI will ignore INSERT/UPDATE/DELETE operations unless it is run by users in the tabula user group, for both dynamic and static code.
Example: See step 20 of the LOADMIGUSERS procedure.