17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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