Function Class Property Descriptions - Teradata Meta Data Services

Function Class Property Descriptions

Table 53: Function Class Property Descriptions 

Property Name	Description
FunctionID	Teradata assigned identifier for a non-built in function
DatabaseID	Teradata assigned identifier for the database
RequestText	The create text for a user-defined function
LastAlterTimestamp	Time that Teradata last updated the object
CreatorName	Name of the Teradata user that created the function
CommentString	Comment stored in Teradata for the function
FunctionClass	Class for the Teradata function or the user defined function Valid values are: Function Call = an instance of a function call. The call parameters are stored in the FunctionCallParameters property. Teradata BuiltIn = Teradata built-in function UDF = general user defined function UDF: Method = user defined function that is defined within a User Defined Type (UDT) UDF: Aggregate = user defined aggregate function UDF: Ordered analytical = user defined ordered analytic window aggregate function UDF: Table UDF = user defined table function UDF: Teradata Internal = a UDF used internally by the Teradata database UDT: Constructor = a user defined function that is the constructor for a UDT
FunctionAlias	Alias used for the function in an SQL statement
FunctionReturnType	Return type for the function
SynchronizationLevel	Internal flag
FunctionSpecificName	The specific name for the user defined function
FunctionCallParameters	The actual parameters passed to the function

The following notes apply to constants referenced by a view column and functions referenced by view columns, stored procedures, macros, and so on.

If a constant is used in an expression with a table column or function, the constant and expression are not stored in the repository. Only the column or function are stored and associated with the view column.

For example, when a view column references expressions (c1 + 10) and [sum(c1) + 10], where c1 is a table column, 10 is a constant, and sum(c1) is a function, only table column c1 and function sum(c1) are stored in the repository and associated with the view column. The constant 10 and expressions (c1 + 10) and [sum(c1) + 10] are not.

If a function is used in combination with other functions, each individual function is stored in the repository and associated with the view column, whereas the combination of functions is not.

For example, when a view column references the expression [sum(c1) + avg (c1)], only the functions sum(c1) and avg (c1) are stored in the repository and associated with the view column.