Reset Look And Feel

Enables you to reset all window tab positions for Builder and Scheduler panes. Resets scheduler and report headings.

Maximize WhereScape RED on Startup

Select the check box to start WhereScape RED in full-screen mode.

Show Dimension Views as a Separate Object Type

Select the check box to display a new object group called Dimension Views where all view objects are stored.  This option is selected by default.

Show Window Tabs At Top

Select the check box to display window tabs at the top of the screen.

Scheduler Results in Color

Select the check box to turn on job status color coding in the scheduler. This option is selected by default.

Maximum rows returned for Display Data

This option sets the maximum number of rows that are returned when displaying data.  This is set to 1000 by default.

Update Column then Previous/Next Wraps to End/Start

Select the check box to control the behavior of the directional Update buttons on the Column Properties window. When enabled, the < Update button will wrap to the last column when it moves beyond the first column; and the Update > button will wrap to the first column when it moves beyond the last column. When deactivated (default), the window closes after an attempt to navigate before the first column or after the last column.

Show Grid Lines in the Middle Pane

Select the check box to display grid lines in the main work area.

Show Grid Lines in the Results Pane

Select the check box to display grid lines in the results area.

Show Grid Lines in the Reports Pane

Select the check ox to display grid lines in the reports area.

List Projects for Object list

Select the check box to display the projects for each object in the middle pane object list.

List Storage for Object list

Select the check box to display the storage for each object in the middle pane object list.

Tree Item Padding

Select the check box to select the number of pixels used to pad tree items when the tree items represent an Object; for example, in the Object Pane and the Browser Pane. Padding is added to the top and bottom of each tree item. Padding can be set from 0-10 pixels, default value is 2.

Show Code as Word Wrapped

Enables you to have word wrapping applied to code by default.

Code Editor Font

Enables you to select the font used in the code editors.

Code Editor Background Color

Enables you to select the background color when editing code.

Code View Background Color

Enables you to select the background color when viewing code.

Procedure Indent Size

Enables you to specify the number of spaces that are generated when a TAB character is used within the Procedure editor. Permitted range is 2 through 10.

Script Indent Size

Enables you to specify the number of spaces that are generated when a TAB character is used within the Script editor. Permitted range is 2 through 10.

Template Indent Size

Enables you to specify the number of spaces that are generated when a TAB character is used within the Template editor. Permitted range is 2 through 10.

Prompt to Regenerate Indexes when Rebuild Procedures

When selected, always prompts for index regeneration whenever an update procedure is rebuilt.

Prompt to Regenerate Action Scripts

When selected, always prompts before Action Script regeneration whenever an Object's metadata has changed such that the Action Script and associated Object's Action Scripts need updating.

Prompt when Truncate Table via Context Menu

When selected, always pops up a confirmation message before the truncate command is executed.

Diagram Column Details

Select the checkbox to display the columns as the initial diagram.

Tracking Report Indentation

Select the checkbox to include tabs in the output to show dependency level.

Show Property Grid Item Description

Select to display the property grid item description. The check box is selected by default.

Show Property Grid Toolbar

Select to display the property grid toolbar. The check box is selected by default.

Show Property Grid Inplace Buttons

Select to display property grid buttons for all items. The check box is selected by default.

Default Property Grid Sort Order

Enables you to select the default property grid sort order for items. The options are:

• Categorized (default)
• Alphabetical
• No Sort

Display Property Grid Boolean as

Enables you to select how Boolean items are to be displayed. The options are:

• Text (default)
• Check box

Text for Boolean True

Enables you to enter the text for the Boolean value False.

Highlight Property Grid Changes

Enables you to highlight changed items in the property grid. The default is True.

Minimum displayed lines for Multiple-Line items

Sets the minimum display lines for multi-line inputs.

Maximum displayed lines for Multiple-Line items

Sets the maximum display lines for multi-line inputs.

Use Local Naming Conventions

Select the checkbox to enable the Local Naming of Tables, Key Columns, and Indexes options in the object tree.

Source Mapping Prefix

Enables you to set the prefix used in the default source mapping naming convention.

Source Mapping Name Type

Enables you to set the basis for the source mapping naming.

Source Mapping Suffix

Enables you to set the suffix used in the default source mapping naming convention.

Key Prefix

Sets the prefix used in the default key naming convention.

Key Name Type

Sets the basis for the key naming.

Key Suffix

Sets the suffix used in the default naming convention.

Index Prefix

Enables you to set the prefix used in the default index naming convention.

Index Name Type

Enables you to set the basis for the index naming.

Index Suffix

Enables you to set the suffix used in the default index naming convention.

Local Documentation Directory

Sets the Local Documentation Directory

Backup Executable

Sets the override for backup executable. By default, WhereScape RED tries to find the path of the backup executable. This edit box provides the ability to specify the exact location and name of the executable. This is useful when WhereScape RED cannot find the program or if there are multiple versions of the program on the PC.

Restore Executable

Sets the override for restoring executable. By default, WhereScape RED tries to find the path of the restore executable.This edit box provides the ability to specify the exact location and name of the executable. This is useful when WhereScape RED cannot find the program or if there are multiple versions of the program on the PC.

Versions to Disk options

Sets the locations and names. If any of the three version-to-disk paths are set, WhereScape RED automatically creates ASCII files containing the applicable DDL or code, each time an automated version occurs in the entered directory.

Output File Directory

Enables you to set the path for output files created from the middle pane.

Output File Extension

Select the checkbox to set the file extension for output files created from the middle pane. This value determines the program that will auto open files.

Output File Auto Open

Select the checkbox to automatically open the results in files created from the middle pane.

Output File Delimiter

Enables you to set the characters that separate each field within each record of output files created from the middle pane. Common values are , and

.

Output File Delimiter String Replace

Enables you to set the characters that will replace the delimiter character if it occurs inside a field.

Output File String Encapsulation

Enables you to set the characters that are used to enclose string values of files created from the middle pane. Common values are " and '.

Output File String Encapsulation Replace

Enables you to set the characters that will replace the encapsulation string if it occurs inside a field.

Output File End Of Line

Enables you to set the characters saved at the end of each record of files created from the middle pane. Common values are \n, \r and \t.

Output File End Of Line Replace

Enables you to set the characters that will replace the end of line string if it occurs inside a field.

Clipboard Delimiter

Enables you to set the characters that separate each field within each record of clipboard output created from the middle pane. Common values are , and

.

Clipboard Delimiter String Replace

Enables you to set the characters that will replace the delimiter character if it occurs inside a field.

Clipboard String Encapsulation

Enables you to set the characters that are used to enclose string values of clipboard output created from the middle pane. Common values are " and '.

Clipboard String Encapsulation Replace

Enables you to set the characters that will replace the encapsulation string if it occurs inside a field.

Clipboard End of Line

Enables you to set the characters saved at the end of each record of clipboard output created from the middle pane. Common values are \n, \r and \t.

Clipboard End of Line Replace

Enables you to set the characters that will replace the end of the line string if it occurs inside a field.