The EXEC_SQL administration method executes SQL statements, with the exception of SQL Select statements.
The EXEC_SQL method returns TRUE if the operation succeeds or FALSE if it fails.
You must have superuser privileges to run the EXEC_SQL method.
Note the following restrictions on how the method works:
If you use the Apply method to execute the method and the query contains commas, you must enclose the entire query in single quotes.
In an EXECUTE statement, character-string literals must always be single-quoted.
To run the EXEC_SQL administration method:
Navigate to Administration > Job Management > Administration Methods.
The system displays the Administration Methods list page.
Click EXEC_SQL.
The system displays the Parameters page.
Type a SQL statement.
The statement must not include a Select clause.
Click Run.
The method runs and the results are displayed.
Click Close.
The system displays the Administration Methods list page.