Previous Topic: Define PostgreSQL Table PropertiesNext Topic: Define SAS Table Properties


Define Progress Table Physical Storage Properties

Use the General tab in the Progress Table Editor to define table physical properties and to designate where the triggers that you define will be stored in the database. This procedure assumes you are working in a physical model, with Progress defined as the target server.

To define physical properties for a Progress table

  1. Click Tables on the Model menu.

    The Progress Table Editor opens.

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

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new table. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

  3. Click the General tab and work with the following options:
    Dump File

    Lets you specify the dump file used by the table contents when a database dump is performed.

    Label

    Lets you specify the name to use in the description of tables in the database catalog.

  4. Click the Volumetrics tab and work with the following options:
    Initial Row Count

    Defines row count for the table. Enter a value in the field.

    Max Rows

    Defines row sizing for the table. Enter a value in the field.

    Growth By Month

    Defines growth increments for the table. Enter a value in the field.

  5. Work with the other tabs in the editor to access additional design features, for example:
  6. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  7. (Optional) Click the Where Used tab to view where the object is used within the model.
  8. (Optional) Click the UDP tab to work with user-defined properties for the object.
  9. (Optional) Click the History tab to view the history information for the object.
  10. (Optional) Click the Notes tab to view and edit user notes.
  11. (Optional) Click the Extended Notes tab to view or edit user notes.
  12. Click Close.

    The physical properties are assigned and the Progress Table Editor closes.