Physical Modeling › Stored Procedures › Add a Stored Procedure for a Table or View › Add a User Defined Property Value for a Stored Procedure

Add a User Defined Property Value for a Stored Procedure

You can use the UDP tab of the Stored Procedures dialog to add or change a user-defined property for the selected stored procedure.

To define a user defined procedures for a stored procedure

1. Click Stored Procedures, Model-Level or Table-Level on the Database menu.

   The Stored Procedures dialog opens.

   Note: For a Teradata DBMS, the Database menu selection is Macros, and it opens the Macros dialog.

2. Select the stored procedure that you want to specify user-defined properties for from the Stored Procedure list and click the UDP tab.

   The name and value of the user-defined property (UDP) associated with the stored procedure is displayed. When you use the Command datatype for a UDP, the Property box is a button that you can click to launch a file or application that you enter in the Value box. If you use a default value when you create a UDP, the property value is automatically specified. Otherwise, you can enter or select a property value depending on the value datatype.

3. You can complete the fields on the General and Expanded tabs and then optionally select the Comment or UDP tab to add a comment or user defined property. Click OK.

   Your changes are saved and the Stored Procedures dialog closes.

   Note: Click Cancel to close the dialog without saving your changes.

More information:

Create a User-Defined Property