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 |