Creating Models › Target Servers for Physical Models › Database Property Editors › Teradata Physical Property Editors › Define Teradata Methods

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 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:
   • Complete the fields on the Data Access tab. See Specify Data Access Options for a Teradata Method for more information.
   • Complete the fields on the Parameters tab. See Specify Parameters for a Teradata Method for more information.
   • Complete the fields on the Return tab. See Specify the Return Values for a Teradata Method for more information.
   • Add a full path for source files for the selected method on the Source Files tab.
   • Add external files for the selected method on the External tab.
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