Previous Topic: Define Teradata Macros

Next Topic: Specify Data Access Options for a Teradata Method

Define Teradata Methods

You can use the Teradata Method Editor to define the body of a method that is associated with a user-defined type in a Teradata physical model. You access the Method Editor from the Domains node in the Model Explorer. If no methods exist on a selected domain, click New to create the method before attempting to open the Teradata Method Editor.

To define a Teradata method

  1. Expand a Domain in the Model Explorer, right-click a Method, and select Properties.

    The Teradata Method Editor opens.

  2. Select a method and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a new method. Use the Enter filter text text box to filter a very large list of methods to quickly locate the one you want to work with.

    Name

    Specifies the name of the method.

    Generate

    Generates DDL for this object during Forward Engineering.

    Use Replace Syntax

    Lets you select whether Forward Engineering will use the REPLACE command instead of the CREATE command.

  3. Work with the other tabs in the editor to access additional design features, for example:
  4. (Optional) Click the Comment tab and enter any comments you want associated with the method.
  5. (Optional) Click the UDP tab to work with user-defined properties for the method.
  6. (Optional) Click the Notes tab to view history information and view or edit user notes.
  7. Click Close.

    The Teradata Method Editor closes.

More information:

Specify Source Files for a Physical Object

Specify the Return Values for a Teradata Method

Specify External Files for a Physical Object

Specify Parameters for the Selected Physical Object

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor