Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

You can use this view to query for information on a 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