Relationships and Domains › Domains and Data Modeling › Domains in the Physical Model › Specifying Database-Specific Options For a Domain › Define Progress Domain Properties

Define Progress Domain Properties

In a model based on a Progress target server, you use the Progress tab in the Domain Editor to manage the data type, null option, and other properties for the selected domain.

Note: The options described here are the basic options available for most physical data types. There can be more options available depending on the physical data type you assign to the domain. We recommend that you refer to your Progress documentation for more information about using these properties.

To specify Progress domain properties

1. Click Domains on the Model menu.

   The Domain Editor opens.

2. Select the domain in the Navigation Grid that you want to define.

   Note: Click New on the toolbar to create a new domain. Use the Enter filter text box to filter a very large list of domains to quickly locate the one that you want to define.

3. Click the Progress tab and work with the following options:

   Physical Data type

   Lets you select a data type from the drop-down list to apply to the selected domain. If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. For example, you can select the DECIMAL() data type and specify a precision of 2 and a scale of 10 inside the parentheses to assign the data type DECIMAL(2,10) to the selected domain.

   Null Option

   Lets you specify a null option.

   Percent Null

   Lets you enter the estimated percentage of nulls used for columns if the option is available. Use whole numbers. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values.

   Format

   Lets you assign a display format. The display format controls how data appears in Progress applications. For example, dd-mmm-yy displays a date value as 01-May-10. For CHAR(n) data types, if you do not specify a format, the format is automatically generated as X(n), where n is the number of characters defined in the data type. Click New to add a new display format or click the button to open the Progress Display Format Editor to work with an existing display format.

   Label

   Lets you enter a name (up to 48 characters) that identifies the column values in Progress applications. By default, the column name with a colon appended is inserted (for example, customer_name:).

   Column-Label

   Lets you enter a name (up to 48 characters) that identifies the column values in a tabular layout in a Progress application. By default, the column name is automatically inserted in this text box.

   Note: If you do not enter a column label, Progress uses the name in the Label text box.

   Extent

   Lets you enter the number of elements in an array field.

   Order Num

   Lets you enter a number that identifies the display order of a field relative to other fields in a Progress application.

   View As

   Lets you enter a Progress View As phrase that defines the type of widget used to display the column data in a Progress application. The supported widget types are: FILL-IN, EDITOR, RADIO-SET, SELECTION-LIST, and TEXT. The data type of the column determines the types of widget you can select.

   Note: See your Progress documentation for more information about View As phrases.

   Prompt

   Lets you enter information for the field in a Progress application. Progress displays this information as a prompt in a Progress application.

   Column Compression

   Lets you enable compression for the selected column.

   Character Case

   Lets you specify how Progress considers the case of the values stored in database fields for the selected column during processing. For example, table, TABLE, and Table are treated as different values when this option is specified. You can select either None, Case-Specific, or Not Case-Specific.

   Note: This option is only available if you select a character data type, such as CHAR, CHAR(), CHARACTER, and so on.

4. Click Close.

   Domain properties are defined and the Domain Editor closes.