Use the SQL Editor preferences to customize the behaviors and look-and-feel of the SQL Editor. To set preferences for general editor appearance and behaviors, go to .
General Tab
You can specify the following general preference settings:
- Syntax Validation
- Validates the syntax of the SQL statement.
Option Description Enable syntax validation Syntax validation automatically updates the structure of an SQL statement in the Outline view and performs the syntax validation as you edit. The SQL Parser parses the SQL statement according to the grammar for the version of Vantage or Aster specified in the Connection Profile. Disabling validation also disables portability checking and the Outline view.Portability check target Selects the Vantage database type to use as the standard target for portability checks. You must enable syntax validation to select a portability target. Select None to indicate no database type for portability checks (default).
Each line that is not portable to the target is annotated with a check. You can display additional information by placing the cursor over the marker.
Maximum number of lines Specifies the maximum number of lines of SQL content to validate before disabling syntax validation. Select a number that optimizes validation without impacting editor performance. The default is 1000. Clear the check box to indicate no restriction to the number of lines of SQL to validate. Prompt to disable system validation when content exceeds maximum number of lines Displays a message asking if you want to disable system validation. The message displays if the number of lines in the SQL file exceeds the value entered in Maximum number of lines. Show detailed annotation information When selected, enables the SQL Editor to display the list of possible correct syntax options when a syntax error occurs in the SQL statement. - Execute Current Text
- Specifies what delimits the current text when you select Execute Current Text from the SQL Editor menu.
Option Description Execute SQLs between delimiters Selects the delimiter used in text to separate SQL statements for execution. Execute current line Selects only the currently selected line of SQL code is to be executed. Execute SQLs between blank lines Selects to use blank lines as the delimiters for separating SQL statements for execution.
Typing Tab
Select check boxes to enable or disable typing aids that are available when editing in Smart Insert mode. Click to select an option and display the SQL in the Preview text area.
Option | Description |
---|---|
Close single quotes | Inserts characters to close a single quote in the SQL Editor. |
Close double quotes | Inserts characters to close a double quote in the SQL Editor. |
Close parentheses | Inserts characters to close a parentheses in the SQL Editor. |
Close comments | Inserts characters to close multi-line comments in the SQL Editor. For example, if you type /* to indicate the start of a comment, the editor inserts */ to close the comment. |
Begin-End | Adds the End with proper indentation in the SQL Editor, and then moves the cursor to a new line between Begin/End with proper indentation. |