17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

You can use this view to query for information on a particular function.

For information about the possible values for the NoSQLDataAccess and RoutineKind columns, see "NoSQLDataAccess Column" and "RoutineKind Column."

Corresponding Tables

The X view references these additional tables:
  • DBC.AccessRights
  • DBC.Owners

Possible Values for ExecProtectionMode

Value Description
P Protected mode
U Unprotected mode

Possible Values for FunctionType

Value Description
A Aggregate
B Aggregate and statistical
C Contract function
E External stored procedure
F Scalar
H User-defined method
I Internal type method
L Table operator
R Table
S Statistical

Possible Values for MaxOutParameters

Value Description
0 Table function with fixed output parameters.
1 to 2048 Varying output column table function.

Possible Values for ParameterStyle

Value Description
S SQLStyle
G GeneralStyle
I InternalStyle
J JavaStyle
O SQLTable
N InternalSQL_Style

Possible Values for PrepareCount

Value Description
Y PrepareCount option is selected for the statistical function.
N PrepareCount option is not selected.

Possible Values for RefQueryband

Value Description
Y The function references the session query bands.
N The function does not reference the session query bands.

Possible Values for SrcFileLanguage

Value Description
C C
P C++
J JAVA
S SQL
A SAS