Setting Database Development Preferences

Specify general preferences for developing, executing, and debugging procedural objects.

Database Development Preferences

FieldExplanation

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 Non-portable line.

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 Logging Preferences

Setting Perspective Preferences

Setting SQL Editor Preferences

Setting Code Assist Preferences

Setting SQL Files Preferences

Setting Templates Preferences

Setting XML Export Format Preferences

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com