Executing SQL Queries Dynamically
SQL queries can be created and executed dynamically in forms or procedures using the command EXECUTE SQLI – which takes an ASCII file as a parameter.
Example: See step 20 of the LOADMIGUSERS procedure.
Executing SQL Server Code from Priority
SQL Server code can be executed from within Priority using the SQLRUN program. The program takes as a parameter an ASCII file containing the SQL Server code.
Example: See the SQLCHECK procedure.