Creating Models › Target Servers for Physical Models › Database Property Editors › Teradata Common Property Pages › Specify Parameters for the Selected Physical Object

Specify Parameters for the Selected Physical Object

The Parameters tab appears on selected physical object property editors to let you work with parameters associated with the selected physical object. You can create, modify, or delete the parameters. You can find this tab on the Function editor, Macro editor, Method editor, and Stored Procedure editor, but the editors may not contain all of the fields described in this section.

To view parameters associated with the selected function

1. Open the property editor for a physical object and click the Parameter tab.

   The Parameter tab opens and the parameters associated with the selected object appear in the main pane.

2. Click the New icon to add a new parameter and update the following fields:

   Parameters

   Shows the name of the parameters that are associated with the selected object.

   Type

   Specifies what type the parameter is. Select from the drop-down list. Valid values are: Input, Output, or Input Output.

   Physical Data Type

   Specifies the data type of the parameters. Select from the drop-down list containing user-defined and physical object data types.

   Is Variant Type

   Specifies whether the parameter is variant type. Select the check box if you want to indicate that the parameter is of variant type.

   Passed By Reference

   Specifies whether the parameter is passed by reference.

   Character Set

   Specifies the type of character set that is used. Select from the drop-down list. Valid values are: Latin, Unicode, Kanji-Shift JIS, Graphic, or Kanji1.

   Character Case

   Specifies whether the parameter is case specific. Select from the drop-down list. Valid values are: None, Case Specific, or Not Case Specific.

   Default

   Specifies the default property type. Select from the drop-down list. Valid values are: Date, Null, System_Generated, Time, or User.

   Format

   Specifies the display format to use.

   Title

   Specifies header text when you print the model.

   Upper Case

   Specifies if the parameter must be upper case.

   Null Option

   Specifies a null option for the selected column. Select from the drop-down list. Valid values are:

   0 - Specifies the NULL clause for the selected column.

   1 - Specifies the NOT NULL clause for the selected column.

   4 - Specifies the CASE clause for the selected column.

   8 - Specifies an IDENTITY clause for the selected column.

3. Click Close.

   The property editor closes.