Previous Topic: Preview the FE ScriptNext Topic: Define Hive Table Properties


Enter Table User-Defined Property Values

Use the UDP tab in the Table Editor to enter user-defined property values for a table.

To enter user-defined property values for a table

  1. Click Tables on the Model menu.

    The Table Editor opens.

  2. Select the table in the Navigation Grid for which you want to enter UDP values.
  3. Click the UDP tab and work with the following options:
    Property

    Displays the name of the user-defined property (UDP) associated with the table. When you use the Command data type for a UDP, the Property cell is a button that you can click to launch a file or application that you enter in the Value cell.

    Value

    Specifies a default value. You can enter or select a property value depending on the value data type:

    • Enter the property value in the Value cell for Integer, Real Number, and Text data types.
    • Enter a date value, click Spin Control Button in UDP tab to change the month, day, and year, or click Down Control to select a date for the Date data type.
    • Select a value from the Value list for the List data type. For example, you can create a UDP to select the backup frequency such as daily.
    • Enter a system command or click Command Data Type Icon in UDP tab to browse for a file or executable program for the Command data type. For example, you can enter or select C:\Myfile.doc to launch the Microsoft Word document Myfile.doc.
  4. Click Close.

    User-defined property values are saved for the table and the Table Editor closes.

Note: You should create UDPs before assigning them to a table. However, you can click Property Editor UDP Tab_User Defined Properties Editor Button to open the User Defined Properties : Physical dialog and work with physical UDPs from within the UDP tab of the Table Editor.