Physical Modeling › Teradata Physical Property Editors › Define Teradata Methods

Define Teradata Methods

You can use the 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 Method Editor.

To define Teradata methods

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

   The Method Editor opens.

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

   Note: Click New on the toolbar to create a new method.

   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. Complete the following fields on the Data Access tab:

   Self As result

   Select to specify the method type is returning the actual user type (preserving).

   Debug

   Select to specify if debug symbols are to be produced.

   Deterministic

   Select to specify if the database function returns the same results given the same input (deterministic).

   Null Input

   Specifies whether a method will be called if a parameter is null. Select from the drop-down list. Valid values are: Called or Returns Null.

   Parameter Style

   Specifies whether the parameters are SQL or Teradata style. Select from the drop-down list. Valid values are: SQL or Teradata General.

   Specific Name

   A string that identifies the method as a database object.

   SQL Data Access

   Specifies whether the SQL statements are permitted in the function. Select from the drop-down list.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Specify the return values for a selected method on the Return tab
   • 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
   • Work with parameter order and options for the selected method on the Parameters tab
5. (Optional) Click the Comment tab and enter any comments you want associated with the method.
6. (Optional) Click the UDP tab to work with user-defined properties for the method.
7. Click Close.

   The 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

View Parameters Associated with the Selected Function

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor