To set scan SQL options
Click in the main menu.
Review the following for additional information:
Automatically start scanning SQL when a job is added | Select this checkbox to start SQL Scanner automatically after you add a scan job. |
Skip SQL within comments | Select this checkbox to ignore SQL statements within comments enclosed by /* */, // and –- in the source code. By default, the scanning algorithm searches for SQL statements contained in comments. |
Skip SQL that does not access any tables | Select this checkbox to ignore SQL statements that do not access tables. |
Whole word matching for the first SQL keyword | Select this checkbox to search for SELECT, INSERT, UPDATE or DELETE as a whole word. When selected, these keywords must be preceded and followed by a space or end of line character. For example, SQL Scanner will not find the word INSERT if it is included in PROCEDUREINSERT. |
Create Scanner Temp Table | Select this checkbox to automatically create a temporary table during scanning when SQL Scanner finds a CREATE TABLE #TEMP or a SELECT INTO #TEMP statement. SQL Scanner automatically drops tables created at the end of the scanning process. |
Include data |
Select this checkbox to automatically execute INSERT, DELETE, UPDATE, and SELECT INTO statements that modify temporary tables SQL Scanner created. Note: Selecting this option may increase total scanning time if SQL Scanner has to load a significant amount of data into the temporary table. |
Override previous Scanner Temp Table |
Select this checkbox to have SQL Scanner create a new temporary table each time it finds a new CREATE TABLE or SELECT INTO statement. Note: Selecting this option does not override User-Defined temporary tables. |
Override User-Defined Temp Table |
Select this checkbox to have SQL Scanner overwrite an existing User-Defined temporary table when it finds a statement to create a table that uses the same name. Note: Selecting this option does not override temporary tables SQL Scanner created. |
Number of characters to skip at the beginning of every line when scanning | Enter the number of characters you want SQL Scanner to skip at the beginning of each line during scanning. |
Skip end of line continuation character | Select the continuation character you want SQL Scanner to skip at the end of each line during scanning. |
Use Temporary Tables in Scan SQL
To set scan SQL options
Click in the main menu.
Review the following for additional information:
Automatically start scanning SQL when a job is added | Select this checkbox to start SQL Scanner automatically after you add a scan job. |
Skip SQL within comments | Select this checkbox to ignore SQL statements within comments enclosed by /* */, // and –- in the source code. By default, the scanning algorithm searches for SQL statements contained in comments. |
Skip SQL that does not access any tables | Select this checkbox to ignore SQL statements that do not access tables. |
Whole word matching for the first SQL keyword | Select this checkbox to search for SELECT, INSERT, UPDATE or DELETE as a whole word. When selected, these keywords must be preceded and followed by a space or end of line character. For example, SQL Scanner will not find the word INSERT if it is included in PROCEDUREINSERT. |
Create Scanner Temp Table | Select this checkbox to automatically create a temporary table during scanning when SQL Scanner finds a CREATE TABLE #TEMP or a SELECT INTO #TEMP statement. SQL Scanner automatically drops tables created at the end of the scanning process. |
Include data |
Select this checkbox to automatically execute INSERT, DELETE, UPDATE, and SELECT INTO statements that modify temporary tables SQL Scanner created. Note: Selecting this option may increase total scanning time if SQL Scanner has to load a significant amount of data into the temporary table. |
Override previous Scanner Temp Table |
Select this checkbox to have SQL Scanner create a new temporary table each time it finds a new CREATE TABLE or SELECT INTO statement. Note: Selecting this option does not override User-Defined temporary tables. |
Override User-Defined Temp Table |
Select this checkbox to have SQL Scanner overwrite an existing User-Defined temporary table when it finds a statement to create a table that uses the same name. Note: Selecting this option does not override temporary tables SQL Scanner created. |
Number of characters to skip at the beginning of every line when scanning | Enter the number of characters you want SQL Scanner to skip at the beginning of each line during scanning. |
Skip end of line continuation character | Select the continuation character you want SQL Scanner to skip at the end of each line during scanning. |
Use Temporary Tables in Scan SQL
To set manage plan guides options
Click .
Review the following for additional information:
Plan Guide List | Select checkbox to automatically validate each plan guide at start. |
Backup File Prefix | Specify a prefix for SQL Optimizer to use when creating a file name for the output or backup file when exporting, importing, or migrating plan guides. |
To set manage plan guides options
Click .
Review the following for additional information:
Plan Guide List | Select checkbox to automatically validate each plan guide at start. |
Backup File Prefix | Specify a prefix for SQL Optimizer to use when creating a file name for the output or backup file when exporting, importing, or migrating plan guides. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center