8.6. Function Metadata

SYS.Functions

This table supplies information about the functions in the virtual database.

Expand

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.

Expand

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.