SQL Scanner Window
View SQL Scanner Window
The SQL Scanner window has 3 panes, a status bar and a toolbar.
Job List Pane
The grid from the SQL Scanner window stores information on each individual Job in the Group. It displays the following:
| Column Heading | Description | |
|
File / Database Object |
Checkbox |
Indicates if the job is selected |
|
Type of job icon and text |
| |
|
| ||
|
| ||
|
| ||
|
| ||
|
| ||
|
Status |
Displays the current Job status. This column is blank until the Job is scanned. After the Job is scanned it displays the number of SQL statements found. | |
|
Displays the number of valid SQL statements found in the Job. Valid SQL statements are syntactically correct statements recognized by the SQL Scanner, and for which Adaptive Server can provide a query plan. Valid SQL statements are further classified as Simple, Complex and Problematic SQL statements. | ||
|
Problematic SQL |
Displays the number of Problematic SQL statements found. If the Show Checked SQL figures on the SQL Scanner window option is selected within Preferences you will notice that there are two figures, first one indicates the number of Problematic SQL that have not been checked and the other (enclosed in brackets) is the number of Problematic SQL that have been checked. The total of these two figures represents the total number of Problematic SQL statements. | |
|
Complex SQL |
Displays the number of Complex SQL statements found. If the Show Checked SQL figures on the SQL Scanner window option is selected within Preferences you will notice that there are two figures, first one indicates the number of Complex SQL that have not been checked and the other (enclosed in brackets) is the number of Complex SQL that have been checked. The total of these two figures represents the total number of Complex SQL statements. | |
|
Simple SQL |
Displays the number of Simple SQL statements found. If the Show Checked SQL figures on the SQL Scanner window option is selected within Preferences you will notice that there are two figures, first one indicates the number of Simple SQL that have not been checked and the other (enclosed in brackets) is the number of Simple SQL that have been checked. The total of these two figures represents the total number of Simple SQL statements. | |
|
File Size |
Displays the size of the Job in bytes. | |
|
Started At |
Displays the date and time when the scanning the Job began. | |
|
Displays the total time taken to scan the Job. The time displays in the HH24:MI:SS format. | ||
[Database] [User] Object type -> Object type
[Database] [User] Text/Binary -> Path/File Name
[Database] [User] COBOL -> Path/COBOL File Name
[Database] [User] Group -> [Database] [User] APGroup -> Abstract Plan Group
Collector -> Collector Name
Inspector -> Inspector NameSQL Text Pane
The left pane of the SQL Scanner window displays the scanned SQL statement for a particular scan Job. The SQL statement is formatted according to SQL Formatter’s indentation algorithm. If more than one SQL statement is found in a Job, there are multiple tabs at the bottom of this pane for selecting the SQL. The tabs are color-coded to the SQL type classification if the Use color tabs for SQL classification option is selected in the Preferences window. Problematic SQL is red. Complex SQL is purple. Simple SQL is green. Invalid SQL is blue. Checked SQL is grey.
SQL Information Pane
The SQL Information Pane provides detailed information about the SQL statement.
Status Bar
The Status Bar at the bottom of the SQL Scanner window contents the following information:
| Item | Description |
|
Data Directory |
Directory path where all the data files produced during scanning are saved. The data directory path can be changed in the Preferences window. While scanning, a progress bar displays to show scanning progress. The upper bar shows the current job progress, while the lower bar shows the total Job status. |
|
Group |
Name of the currently opened Scanner Group. |
|
Total Jobs |
Total number of Jobs. |
|
Completed |
Total number of Jobs already scanned. |
|
Remaining |
Total number of Jobs that have not been scanned. |