15.10 - FunctionsV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

FunctionName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

UDFInfo.FunctionName (Composite NUPI)

SpecificName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

FunctionId

BYTE(6)

NOT NULL

X(12)

UDFInfo.FunctionId (USI)

NumParameters

SMALLINT

NOT NULL

---,--9 (explicit)

UDFInfo.NumParameters

ParameterDataTypes

VARCHAR(256) LATIN

UPPERCASE

NOT CASESPECIFIC

X(255) (explicit)

UDFInfo.ParameterDataTypes

FunctionType

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.FunctionType

ExternalName

CHAR(30) LATIN

CASESPECIFIC

NOT NULL

X(128)

UDFInfo.ExternalName

SrcFileLanguage

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.SrcFileLanguage

NoSQLDataAccess

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.NoSQLDataAccess

ParameterStyle

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.ParameterStyle

DeterministicOpt

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.DeterministicOpt

NullCall

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.NullCall

PrepareCount

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.PrepareCoun

ExecProtectionMode

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.ExecProtectionMode

ExtFileReference

VARCHAR(1000)

UNICODE

CASESPECIFIC

X(255) (explicit)

UDFInfo.ExtFileReference

CharacterType

SMALLINT

NOT NULL

---,--9 (explicit)

UDFInfo.CharacterType

Platform

CHAR(8) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(8)

UDFInfo.Platform

InterimFIdSize

INTEGER

NOT NULL

--,---,---,--9

UDFInfo.InterimFIdSize

RoutineKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.RoutineKind

ParameterUDTIds

VARBYTE(512)

X(512) (explicit)

UDFInfo.ParameterUDTIds

AuthIdUsed

BYTE(6)

X(12) (explicit)

TVM.AuthIdUsed

MaxOutParameters

SMALLINT

NOT NULL

---,--9 (explicit)

UDFInfo.MaxOutParameters

GLOPSetDatabaseName

VARCHAR(128)

UNICODE

UPPERCASE NOT

CASESPECIFIC

X(128)

UDFInfo.GLOPSetDatabaseName

GLOPSetMemberName

VARCHAR(128)

UNICODE

UPPERCASE NOT

CASESPECIFIC

X(128)

UDFInfo.GLOPSetMemberName

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • You can use this view to query for information on a particular function.

    For information about the possible values for the NoSQLDataAccess and RoutineKind columns, see Appendix A: “View Column Values.”

    ParameterDataTypes

    The ParameterDataTypes column can list a maximum number of 128 parameters.

    Possible Values for ExecProtectionMode

     

    Value

    Description

    P

    Protected mode

    U

    Unprotected mode

    Possible Values for FunctionType

     

    Value

    Description

    A

    Aggregate

    B

    Aggregate and statistical

    C

    Contract function

    E

    External stored procedure

    F

    Scalar

    H

    User-defined method

    I

    Internal type method

    L

    Table operator

    R

    Table

    S

    Statistical

    Possible Values for MaxOutParameters

     

    Value

    Description

    0

    Table function with fixed output parameters.

    1 to 2048

    Varying output column table function.

    Possible Values for ParameterStyle

     

    Value

    Description

    S

    SQLStyle

    G

    GeneralStyle

    I

    InternalStyle

    J

    JavaStyle

    O

    SQLTable

    N

    InternalSQL_Style

    Possible Values for PrepareCount

     

    Value

    Description

    Y

    PrepareCount option is selected for the statistical function.

    N

    PrepareCount option is not selected.

    Possible Values for SrcFileLanguage

     

    Value

    Description

    C

    C

    P

    C++

    J

    JAVA

    S

    SQL

    A

    SAS

    The following SELECT statement displays information about the overloaded functions named 'concat' in 'dba' database:

    ==> SELECT SpecificName, NumParameters, ParameterDataTypes FROM FunctionsV WHERE DatabaseName = 'dba' and FunctionName = 'concat' order by 1,2,3;

    Result:

    SpecificName  NumParameters ParameterDataType
    ------------- ------------- -----------------

    concat        2             CFCF
    concat_3      3             CFCFCF
    concat_4      4             CFCFCFCF