ExternalSPsV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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 External Stored Procedure resides.
ExternalProcedureName VARCHAR(128) UNICODE UPPERCASE NOT NULL X(128) Identifies the name of an External Stored Procedure.
ExternalProcedureId BYTE(6) NOT NULL X(12) Specifies the unique ID of an External Stored Procedure.
NumParameters SMALLINT NOT NULL ---,--9 Returns the number of parameters of a function.
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.
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).
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.
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.
AppCategory CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the application category of an external stored procedure.
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.