Previous Topic: Define Teradata Methods

Next Topic: Specify the Return Values for a Teradata Method

Specify Data Access Options for a Teradata Method

Work with the Data Access tab on the Teradata Method Editor to specify data access options.

To specify data access options for a Teradata Method

  1. Open the Teradata Method Editor and click the Data Access tab.

    The Data Access tab opens.

  2. Work with the following fields on the Data Access tab:
    Self As Result

    Specifies whether the method is type preserving (returns the actual use type).

    Debug

    Specifies whether debug symbols are to be produced.

    Deterministic

    Specifies whether the method is deterministic.

    Null Input

    Specifies whether a method is 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 General style. Select from the drop-down list.

    Specific Name

    Specifies the method as a database object.

    SQL Data Access

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

    Language

    Specifies what language the method is written in. Select from the drop-down list. Valid values are: C or CPP (C++).

    Global Persistent Data Set (Teradata Version 13 only)

    Specifies the GLOP data set. Select from the drop-down list.

    Compile

    Specifies the mode that the method should be compiled in. Select from the drop-down list. Valid values are: Compile and Build, or Compile Only.

    Execute

    Specifies what mode to execute the method in. Select from the drop-down list. Valid values are: Protected or Not Protected.

  3. Click Close.

    The Teradata Method Editor closes.