SYS.Functions

このテーブルでは、データソースとシステムスキーマの機能に関する情報を提供します。

Column Name

Type

Description

VDBName

string

VDB name

SchemaName

string

Schema name

Name

string

Function name

NameInSource

string

Function name in the source system

UID

string

Function UID

Description

string

Description set by the user

OriginalDescription

string

Description set by the system

IsVarArgs

boolean

Whether the function accepts variable arguments or not

SYS.Functions table is available since v4.6

SYS.Functions contains information about data source functions since v4.8

OriginalDescription column is available since v4.8

SYS.FunctionParams

関数のパラメータに関する情報を提供します。

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

CData Virtuality Server runtime data type name

Position

integer

Position in function arguments

Type

string

Parameter direction: "In", "Out", "InOut", "ResultSet", "ReturnValue"

Precision

integer

Precision of parameter

TypeLength

integer

Length of the parameter value

Scale

integer

Scale of parameter

Radix

integer

Radix of parameter

NullType

string

Nullability: "Nullable", "No Nulls", "Unknown"

UID

string

Function UID

Description

string

Description set by the user

OriginalDescription

string

Description set by the system

SYS.FunctionParams table is available since v4.6

SYS.FunctionParams contains information about data source function parameters since v4.8

OriginalDescription column is available since v4.8