17.00 - FunctionsV[X] - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Operations

Database: DBC

View Column Data Type Format Comment
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database in which the function resides.
FunctionName VARCHAR(128) UNICODE UPPERCASE NOT NULL X(128) Returns the user-assigned name in internal format.
SpecificName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the specific (unique) name of a function.
FunctionId BYTE(6) NOT NULL X(12) Returns the unique ID of a function.
NumParameters SMALLINT NOT NULL ---,--9 Returns the number of parameters of a function.
ParameterDataTypes VARCHAR(256) LATIN UPPERCASE X(256) Returns the parameter list of a function with a two-character string representing the data type for each parameter. The maximum parameter is 128.
FunctionType CHAR(1) LATIN NOT CASESPECIFIC X(1) Function type: A (aggregate), B (aggregate and statistical), F (scalar), R (table), S (statistical).
ExternalName CHAR(30) LATINC NOT NULL X(30) Returns the external name of a function. For SQL UDFs, the value is always SQLUDF.
SrcFileLanguage CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the source file language used to implement a user-defined function (UDF).
NoSQLDataAccess CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the access indicated in the 'Create Procedure' statement. Y = No SQL in the external stored procedures;C = Contains SQL;R = Reads SQL data;M = Modifies SQL data;
ParameterStyle CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the parameter passing convention for the function or an External Stored Procedure. The following codes are used: S = SQL, G = TD_GENERAL, I = for internal.
DeterministicOpt CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns whether the function returns the same results for identical inputs or not. These are the values: Y = deterministic, N = not deterministic. The default is N.
NullCall CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns whether the function is called on null input.
PrepareCount CHAR(1) LATIN UPPERCASE X(1) Returns the single character field representing the Prepare Count statistical option.
ExecProtectionMode CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns whether the function can be executed directly with a call statement (not protected) or indirectly as a separate process (protected) a call statement (not protected) or indirectly as a separate process (protected).
ExtFileReference VARCHAR(1000) UNICODE CASESPECIFIC X(1000) Saves the external file reference provided in the CREATE/REPLACE FUNCTION or external stored procedure statement.
CharacterType SMALLINT NOT NULL ---,--9 Returns the character type that was the default when the function or External Stored Procedure was created.
Platform CHAR(8) LATIN UPPERCASE NOT NULL X(8) Returns the platform of the system on which the object is compiled.
InterimFldSize INTEGER NOT NULL --,---,---,--9 Returns the interim field size defined for an aggregate user-defined function.
RoutineKind CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns a single character indicating the family of the routine.
ParameterUDTIds VARBYTE(512) X(1024) Returns a series of 4-byte UDT- type identifiers.
AuthIdUsed BYTE(6) X(12) Returns the identifier of the authorization being used for the External Stored Procedure or User Defined Function.
MaxOutParameters SMALLINT NOT NULL ---,--9 Returns the maximum output parameters for a table function.
GLOPSetDatabaseName VARCHAR(128) UNICODE UPPERCASE X(128) Returns the name of the database to which the GLOP set belongs for the member clause.
GLOPSetMemberName VARCHAR(128) UNICODE UPPERCASE X(128) Returns the name of the GLOP set to which the XSP/UDF/UDM belongs. It is zero length when the external routine or UDF/UDM is not a member of the set.
RefQueryband CHAR(1) LATIN UPPERCASE X(1) Returns Y if the function references the current query bands for the session. The default is N.
ExecMapName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the execution map name of a table operator. NULL indicates the table operator does not have a execute map.
ExecMapColocName VARCHAR(128) UNICODE UPPERCASE X(128) Returns the ColocationName of the execution map of a table operator.