Category: Operations
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| HostNo | SMALLINT NOT NULL | ---,--9 | Returns the number of the client system through which the user logged on to the Teradata Database. |
| SessionNo | INTEGER NOT NULL | --,---,---,--9 | Returns the session identifier assigned to the session by the TDP or LAN interface. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name or profile of a user. |
| B_DatabaseName | VARCHAR(128) UNICODE UPPERCASE NOT NULL | X(128) | Returns the name of the database in which the base global table resides. |
| B_TableName | VARCHAR(128) UNICODE UPPERCASE NOT NULL | X(128) | Returns the name of the base global temporary table. |
| E_TableId | BYTE(6) NOT NULL | X(12) | Returns the identifier for the materialized (effective) temporary table for a base global temporary table. |