Specify general preferences for developing, executing, and debugging procedural objects.
Database Development Preferences
Field | Explanation | |
---|---|---|
Show affordance in hover on how to make it sticky | To display the "Press F2 for focus" message in hover help (ToolTips), select the check box. | |
Portability check target | Specifies the database type that is used as the standard for portability checks. In the SQL Editor, each non-portable
line is annotated with the check icon
| |
Whether to continue when error occurs during SQL execution | Select the action taken on an error during SQL execution. | |
Always | Always continues execution when an error occurs. | |
Never | Always stops execution when an error occurs. | |
Prompt | Interrupts execution on each error, displaying a dialog to resume execution. | |
Whether to continue when error occurs during SQL Execution Plan explanation | Select the action taken on an error during SQL Execution Plan explanation. | |
Always | Always continues execution when an error occurs. | |
Never | Always stops execution when an error occurs. | |
Prompt | Interrupts execution on each error, displaying a dialog to resume execution. | |
Quoted identifier for ASE | When the check box is selected, you can use double quotes to enclose an identifer. | |
Show plan while executing SQL statements | To automatically show the execution plan in the Execution Plan view when executing SQL statements, select the check box. | |
Plan options (ASA) | ||
Plan option | Specify the format for execution plans in ASA: | |
Short Description | Select when you want to compare plans quickly. | |
Long Description | Provides slightly more information than Short Description. Easy to print and view. | |
Graphics Plan | Displays execution plan information in graphic format. | |
Graphics Plan with Statistics | Similar to Graphics Plan but also displays actual runtime costs of executing the statement. | |
UltraLite Short Description | Displays UltraLite plan optimization strategy in short text format. | |
UltraLite Short Description | Displays UltraLite plan optimization strategy in long text format. | |
UltraLite Graphics Plan | Displays UltraLite plan optimization strategy in graphic format. | |
Plan options (ASE) | ||
Plan option | Specify the format for execution plans in ASE: | |
Text | In ASE, Text is the only available format for execution plans. |
Preferences in Sybase WorkSpace
Preferences in Database Development
Setting Perspective Preferences
Setting SQL Editor Preferences
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com