15.10 - ExternalSPsV[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

ExternalProcedureName

VARCHAR(128)

UNICODE

UPPERCASE

NOT NULL

X(128)

UDFInfo.FunctionName (Composite NUPI)

ExternalProcedureId

BYTE(6)

NOT NULL

X(12)

UDFInfo.FunctionId (USI)

NumParameters

SMALLINT

NOT NULL

---,--9 (explicit)

UDFInfo.NumParameters

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

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

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

AppCategory

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

UDFInfo.AppCategory

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
  • DBC.RoleGrants
  • DBC.Roles
  • For information about the possible values for the NoSQLDataAccess and RoutineKind columns, see Appendix A: “View Column Values.”

    Platform

    The Platform column value is LINUX64. This value is used for both SLES 10 and 11.

    Possible Values for AppCategory

     

    Value

    Description

    C

    CLI

    O

    ODBC

    N

    .NET

    J

    JAVA

    S

    C and CPP external stored procedure or UDF

    Possible Values for ExecProtectionMode

     

    Value

    Description

    P

    Protected mode

    U

    Unprotected mode

    Possible Values for ParameterStyle

     

    Value

    Description

    S

    SQLStyle

    G

    GeneralStyle

    I

    InternalStyle

    J

    JavaStyle

    O

    SQLTable

    N

    InternalSQL_Style

    Possible Values for SrcFileLanguage

     

    Value

    Description

    C

    C

    P

    C++

    J

    JAVA

    S

    SQL

    A

    SAS

    The following SELECT statement returns information about the external stored procedures in database ‘dba’:

    ==> SELECT * FROM DBC.ExternalSPsV
    WHERE databasename = ‘dba’;

    Result:

    DataDatabaseName      dba
    ExternalProcedureName XSP_100
    ExternalProcedureId   00006E0F0000
    NumParameters         2
    ExternalName          xsp_100
    SrcFileLanguage       C
    NoSQLDataAccess       Y
    ParameterStyle        S
    ExecProtectionMode    P
    ExtFileReference      CS!xsp_100!/home/i18n/ckl/udftest/xsp_100.c
    CharacterType         1
    Platform              LINUX64
    RoutineKind           R
    ParameterUDTIds
    AuthIdUsed            00001E0A0000
    AppCategory           S
    GLOPSetDatabaseName   ?
    GLOPSetMemberName     ?