SQL statements saved in the SQL Repository can be copied into the SQL Optimizer, SQL Formatter, or SQL Worksheet.
To open a SQL statement from the SQL Repository
In the SQL Optimizer, SQL Formatter, or SQL Worksheet., select Edit | Open SQL from SQL Repository.
Navigate through the tree structure and select the SQL statement.
Either double-click the SQL statement, or click Open.
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.
All the SQL statements can be saved in a text file from the SQL Scanner, the SQL Repository, the SQL Inspector, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory 4.6 or later.
To create a file to import into Benchmark Factory
Right-click and select Create Benchmark Factory Import File.
Select the specific SQL statements that you want to save.
Enter the filename and select the file location.
You can navigate through multiple SQL statements tabs using the following methods.
Click the tab set located at the bottom of the window.
Use the SQL | Go to SQL function which navigates to a specify SQL number.
Use the navigation buttons on the toolbar or select the corresponding menu item.
Menu | Button |
Navigate | First SQL |
|
Navigate | Previous SQL |
|
Navigate | Next SQL |
|
Navigate | Last SQL |
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center