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. |