SQL statements saved in the SQL Repository can be copied to the editable pane in other modules.
To copy SQL from the SQL Repository
From an editable pane in a module other than the SQL Repository, select File | Open SQL from SQL Repository.
Navigate through the tree structure and select the SQL statement.
Click Open.
To save SQL statements to the SQL Repository module
Click .
Select the specific SQL to save and click the Save button.
Select the location in which to save the SQL statements.
Only valid SQL statements can be added to the SQL Repository.
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 Job Manager, the Scanned SQL Viewer, the SQL Repository, and the SQL Optimizer windows. These SQL statements can then be imported into Benchmark Factory program (version 4.6 or later).
To create the text 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. Click OK.
Enter the filename and select the file location. Click Save.
Several ways are provided to navigate through the SQL statements displayed in multiple tab sets.
Click the tab set at the bottom of the window.
Use the Navigate | Go to SQL function which navigates to a specify SQL number.
Use the navigation buttons on the toolbar or corresponding menu items.
Button |
Menu Item |
Description |
---|---|---|
|
Navigate | First SQL |
Display the first SQL statement. |
|
Navigate | Previous SQL |
Display the previous SQL statement. |
|
Navigate | Next SQL |
Display the next SQL statement. |
|
Navigate | Last SQL |
Display the last SQL statement. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center