8.6. Function Metadata

SYS.Functions
This table supplies information about the functions in the virtual database.
Column Name
Type
Description
VDBName
string
VDB name
SchemaName
string
Schema Name
Name
string
Function name
NameInSource
string
Function name in source system
UID
string
Function UID
Description
string
Description
IsVarArgs
boolean
Does the function accept variable arguments?
SYS.FunctionParams
This supplies information on functionparameters.
Column Name
Type
Description
VDBName
string
VDB name
SchemaName
string
Schema Name
FunctionName
string
Function name
FunctionUID
string
Function UID
Name
string
Parameter name
DataType
string
Data Virtualization runtime data type name
Position
integer
Position in function args
Type
string
Parameter direction: "In", "Out", "InOut", "ResultSet", "ReturnValue"
Precision
integer
Precision of parameter
TypeLength
integer
Length of parameter value
Scale
integer
Scale of parameter
Radix
integer
Radix of parameter
NullType
string
Nullability: "Nullable", "No Nulls", "Unknown"
UID
string
Function Parameter UID
Description
string
Description
OID
integer
Unique ID

Warning

The OID column is no longer used on system tables. Use UID instead.