Creating Models › Target Servers for Physical Models › Database Property Editors › Teradata Physical Property Editors › Define Teradata Stored Procedures › Specify Data Access Options for a Stored Procedure

Specify Data Access Options for a Stored Procedure

Use the Options tab on the Teradata Stored Procedure Editor to work with data access options.

To specify data access options for a stored procedure

1. Open the Teradata Stored Procedure editor and click the Options tab.
2. Work with the following fields on the Options tab:

   Language

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

   Parameter Style

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

   SQL Data Access

   Specifies whether SQL statements are permitted in the stored procedure. Select from the drop-down list. Valid values are: No SQL, Contains SQL Data, Modifies SQL Data, or Reads SQL Data.

   Dynamic Result Sets (Teradata Version 12 only)

   Specifies the number of dynamic result sets that can be returned. The range of valid values are from 0 through 15, inclusive.

   SQL Security Mode

   Specifies the SQL security mode to be used. Select from the drop-down list. Valid values are: Creator, Definer, Invoker, and Owner.

   Global Persistent Data Set (Teradata Version 13 only)

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

   Debug

   Specifies if the debug symbols are to be produced.

   Compile

   Specifies the mode the stored procedure 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 stored procedure in. Select from the drop-down list. Valid values are: Protected or Not Protected.

   Store Source

   Specifies whether the source code is stored in the dictionary.

   Return Warnings

   Specifies whether to return warnings on compilation errors.

3. Click Close.

   The Teradata Stored Procedure Editor closes.