SQL Navigation
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. |
Find a SQL Using a Text String
The Find SQL function is available in the SQL Optimizer and Scanner SQL Viewer window. It searches through SQL statements until it finds the first occurrence of the text string you specify. In SQL Optimizer, Find SQL searches the SQL syntax currently displayed in the SQL Text pane. In SQL Scanner, the function searches across all SQL statements displayed on the SQL tabs.
To find specific text within the SQL statements
-
Select SQL | Find SQL.
-
Enter the text string to be found and click Find.
-
To continue searching for the same text, select SQL | Find Next SQL [Ctrl + F3].
Comments
Due to the lack of uniform standards in the presentation of comments within source code, it is almost impossible to implement each and every commenting indicator. We have therefore chosen to support the three most popular delimiters:
|
Comment Syntax |
Comment |
|---|---|
|
-- |
single line |
|
// |
single line |
|
starting with /* ending with */ |
block |
During optimization these comments will be removed and will not be shown in the list of optimized SQL statements.
SQL Optimizerdoes not accept any other comment delimiters.
Variables
Variables can be embedded in the original SQL statement without pre-defining the data type and value. All variable names will be highlighted in red after the optimization process. SQL Optimizer will recognize declaration of variables either with or without a ":" (host variables) or "?" (parameter markers) sign. During optimization, run time or run result, the data type and value of the variables will require definition by using the Parameters window.