Category: Operations
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| DatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database in which the function resides. |
| FunctionName | VARCHAR(128) UNICODE UPPERCASE NOT NULL | X(128) | The user-assigned name in internal format. |
| SpecificName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The specific (unique) name of a function. |
| FunctionId | BYTE(6) NOT NULL | X(12) | The unique ID of a function. |
| NumParameters | SMALLINT NOT NULL | ---,--9 | Number of parameters of a function. |
| ParameterDataTypes | VARCHAR(256) LATIN UPPERCASE | X(256) | 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) | The external name of a function. For SQL UDFs, the value is SQLUDF. |
| SrcFileLanguage | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | The source file language used to implement a user-defined function (UDF). |
| NoSQLDataAccess | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | 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) | 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) | Indicates whether the function returns the same results for identical inputs or not. Values are Y = deterministic, N = not deterministic. The default is N. |
| NullCall | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Indicates whether the function is called on null input. |
| PrepareCount | CHAR(1) LATIN UPPERCASE | X(1) | The single character field representing the Prepare Count statistical option. |
| ExecProtectionMode | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Indicates whether the function can run 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 | 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) | The platform of the system on which the object is compiled. |
| InterimFldSize | INTEGER NOT NULL | --,---,---,--9 | The interim field size defined for an aggregate user-defined function. |
| RoutineKind | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | A single character indicating the family of the routine. |
| ParameterUDTIds | VARBYTE(512) | X(1024) | A series of 4-byte UDT- type identifiers. |
| AuthIdUsed | BYTE(6) | X(12) | The identifier of the authorization being used for the External Stored Procedure or User Defined Function. |
| MaxOutParameters | SMALLINT NOT NULL | ---,--9 | Maximum output parameters for a table function. |
| GLOPSetDatabaseName | VARCHAR(128) UNICODE UPPERCASE | X(128) | The name of the database to which the GLOP set belongs for the member clause. |
| GLOPSetMemberName | VARCHAR(128) UNICODE UPPERCASE | X(128) | The name of the GLOP set to which the XSP/UDF belongs. Has zero length when the external routine or UDF is not a member of the set. |
| RefQueryband | CHAR(1) LATIN UPPERCASE | X(1) | Specifies Y if the function references the current query bands for the session. The default is N. |
| ExecMapName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The execution map name of a table operator. NULL indicates the table operator does not have a run map. |
| ExecMapColocName | VARCHAR(128) UNICODE UPPERCASE | X(128) | The ColocationName of the execution map of a table operator. |