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 |