Save SQL to SQL Repository
If you are using this function from the SQL Scanner, you can send multiple SQL statements to the SQL Repository. If you are using this function from the other modules, you can send one SQL statement to the SQL Repository.
To save multiple SQL statements to the SQL Repository module
-
In the SQL Scanner, select the Job which contains the SQL statements. In the SQL Inspector, click in the SQL Text pane.
-
Click Save SQL to SQL Repository
.
-
Select the location in which to save the SQL statements and click OK.
To save a SQL statement to the SQL Repository module
-
In the modules with a SQL Text window, select a SQL statement.
-
Click Save SQL to SQL Repository
-
Select the location in which to save the SQL statements and click OK.
Only valid SQL statements are added to the SQL Repository.
Note: The SQL Repository only supports a single SELECT, INSERT, UPDATE or DELETE SQL statement.