The following table describes the attributes reported by a HELP SESSION request.
Attribute | Data Type | Nullable | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
User Name | VARCHAR(30) | No | Reports the name of the owner of the session. | ||||||||||||
Account Name | VARCHAR(30) | No | Reports the account name in effect for the session. See SET SESSION. | ||||||||||||
Logon Date | CHAR(8) | No | Reports the date of logon to the database, in the format YYYY/MM/DD. | ||||||||||||
Logon Time | CHAR(8) | No | Reports the time of logon to the database, in the format HH:MI:SS. | ||||||||||||
Current Database | VARCHAR(30) | No | Reports the database defined as the default for the session (see DATABASE and CREATE USER). | ||||||||||||
Collation | VARCHAR(15) | No | Reports the sort sequence defined for the session. See CREATE USER and SET SESSION.
|
||||||||||||
Character Set | VARCHAR(30) | No | Reports the character set defined for the session. | ||||||||||||
Transaction Semantics | VARCHAR(8) | No | Reports the whether the session is
in ANSI or Teradata session mode.
|
||||||||||||
Current Dateform | VARCHAR(11) | No | Reports the current mode for export and import of DATE values. For information about date formats, see DateTime and Interval Data Types.
|
||||||||||||
Session Time Zone | VARCHAR(6) | No | Reports the current time zone value
in use by the session, displayed in INTERVAL HOUR TO MINUTE
format. For example, -08:00. This is an offset from UTC. |
||||||||||||
Default Character Type | VARCHAR(30) | No | Reports the default character type for the user logged onto the current session. | ||||||||||||
Export Latin | CHAR(1) | No | Reports the export width value for each character data type for the session. (For information about export widths, see Teradata SQL Character Strings and Client Physical Bytes). | ||||||||||||
Export Unicode | CHAR(1) | No | |||||||||||||
Export Unicode Adjust | CHAR(1) | No | |||||||||||||
Export KanjiSJIS | CHAR(1) | No | |||||||||||||
Export Graphic | CHAR(1) | No | |||||||||||||
Default Date Format | VARCHAR(30) | No | Reports the setting of the default date output format. This custom date format serves as the default output format for dates when DATEFORM is set to IntegerDate. See “User Name” earlier in this table for information about the data type and system-defined character sets for DEFAULT DATE FORMAT. For information about date formats, see FORMAT Phrase and DateTime Formats. |
||||||||||||
Radix Separator | CHAR(1) | No | The character that separates the
integer and fractional part of monetary numeric data. The system copies the value into the output string of numeric data whenever a D appears in the corresponding output FORMAT phrase. |
||||||||||||
Group Separator | CHAR(1) | No | The character that separates groups
of digits in the integer part of monetary strings. The value of Currency Grouping Rule determines when the system copies the value of Currency Group Separator into the output string of numeric monetary data. |
||||||||||||
Grouping Rule | VARCHAR(30) | No | The number of digits to group
together before inserting the value of Currency Group Separator in
the output of monetary numeric data. The grouping rule applies to the output of numeric data that uses a FORMAT phrase containing a G formatting character. |
||||||||||||
Currency Radix Separator | CHAR(1) | No | The character that separates the
integer and fractional part of monetary numeric data. The system returns a value if the format string contains the format element for the currency symbol or name. |
||||||||||||
Currency Group Separator | CHAR(1) | No | The character that separates groups
of digits in the integer part of monetary strings. The system returns a value if the format string contains the format element for the currency symbol or name. |
||||||||||||
Currency Grouping Rule | VARCHAR(30) | No | The number of digits to group
together before inserting the value of Currency Group Separator in
the output of monetary numeric data. The system returns a value if the format string contains the format element for the currency symbol or name. |
||||||||||||
Currency Name | VARCHAR(30) | No | The local currency as a completely spelled-out currency name. The system copies the value into the output string of monetary numeric data whenever an N appears in the corresponding output FORMAT phrase. | ||||||||||||
Currency | VARCHAR(30) | No | The local currency symbol. The system copies the value into the output string of monetary numeric data whenever an L appears in the corresponding output FORMAT phrase. | ||||||||||||
ISOCurrency | VARCHAR(30) | No | The local currency as an uppercase, three-character code from ISO 4217. The system copies the value into the output string of monetary numeric data whenever a C appears in the corresponding output FORMAT phrase. | ||||||||||||
Dual Currency Name | VARCHAR(30) | No | The dual currency as a completely spelled-out currency name. The system copies the value into the output string of monetary numeric data whenever an A appears in the corresponding output FORMAT phrase. | ||||||||||||
Dual Currency | VARCHAR(30) | No | The dual currency symbol. The system copies the value into the output string of monetary numeric data whenever an O appears in the corresponding output FORMAT phrase. | ||||||||||||
Dual ISOCurrency | VARCHAR(30) | No | The dual currency as an uppercase, three-character code from ISO 4217. The system copies the value into the output string of monetary numeric data whenever a U appears in the corresponding output FORMAT phrase. | ||||||||||||
Default ByteInt Format | VARCHAR(30) | No | The default output format applied to BYTEINT data types. | ||||||||||||
Default Integer Format | VARCHAR(30) | No | The default output format applied to INTEGER data types. | ||||||||||||
Default SmallInt Format | VARCHAR(30) | No | The default output format applied to SMALLINT data types. | ||||||||||||
Default Numeric Format | VARCHAR(30) | No | The default output format applied to NUMERIC and DECIMAL data types. | ||||||||||||
Default Real Format | VARCHAR(30) | No | The default output format applied to REAL, DOUBLE PRECISION, and FLOAT data types. | ||||||||||||
Default Time Format | VARCHAR(30) | No | The default output format applied to TIME and TIME WITH TIME ZONE data types | ||||||||||||
Default Timestamp Format | VARCHAR(30) | No | The default output format applied to TIMESTAMP and TIMESTAMP WITH TIME ZONE data types. | ||||||||||||
Current Role | VARCHAR(30) | No | Reports the current role for the session. If no role applies, the system returns an empty string. | ||||||||||||
Logon Account | VARCHAR(30) | No | Reports the account name used to log on to the database. | ||||||||||||
Profile | VARCHAR(30) | No | Reports the name of the profile
associated with this session. See “User Name” earlier in this table for information about the data type and system-defined character sets for Profile. |
||||||||||||
LDAP | CHARACTER(1) | No | Reports whether the session is
authenticated by an LDAP directory and whether the directory user is
mapped to a database user.
|
||||||||||||
Audit Trail ID | VARCHAR(30) | No | Reports the name used for access
logging, regardless of whether the user is Directory-managed or
database-managed. The system stores values for external users who do not have a corresponding permanent user name in the User Name column. |
||||||||||||
Current Isolation Level | CHARACTER(2) | No | Reports the default read-only
isolation level for the current session.
|
||||||||||||
Default BigInt Format | VARCHAR(30) | No | Reports the default output format for the BIGINT data type. If the attribute is Default BIGINT Format, the default output format applies to BIGINT data type |
||||||||||||
Query Band | VARCHAR(8201) | No | If there is no query band, the Query Band text contains an empty string. If there is only a transaction query band, the Query Band text contains the following string.
=T> transaction_queryband
where transaction_queryband is the query band for the transaction.If there is only a session query band, the Query Band text contains the following string.
=S> session_queryband
where session_queryband is the query band for the current session.If there is both a transaction query band and a session query band, the Query Band text contains the following concatenated string.
=T> transaction_queryband =S> session_querybandwhere transaction_queryband is the query band for the transaction and session_queryband is the query band for the current session. |
||||||||||||
Proxy User | VARCHAR(30) | No | If there is a proxy connection in
effect for the session, reports the name of the Proxy User. If there is no proxy connection in effect for the session, the system returns an empty string. |
||||||||||||
Proxy Role | VARCHAR(30) | No | If there is a proxy connection in effect for the session and a role has been assigned to the Proxy User, Proxy Role reports the name of that role. If there is no proxy connection in effect for the session, or if no roles have been assigned to the Proxy User, Proxy Role returns an empty string. |
||||||||||||
Constraint1Name | VARCHAR(30) | No | The name of a row level security
constraint. If no row level security constraint applies, the Constraint_n_Name is null. If the session has more than 1 security constraint, the system displays each with a unique identifying number, for example: Constraint1Name Constraint1Value Constraint2Name Constraint2Value... |
||||||||||||
Constraint1Value | CHAR(68) | No | The value code for the default session label for the Constraint nName. If no row level security constraint applies, the Constraint_n_Value is null. |
||||||||||||
Temporal Qualifier | VARCHAR(1024) | No | Reports the default temporal attribute for the current session. | ||||||||||||
Calendar Name | VARCHAR(128) | No | Reports the default calendar for the current session. | ||||||||||||
Export Width Rule Set | CHAR(40) | No | The export width rule in effect for the session. | ||||||||||||
Default Number Format | VARCHAR(30) | No | The default output format for the NUMBER data type. | ||||||||||||
TTGranularity | VARCHAR(15) | No | Indicates the temporal transaction time granularity for the session. | ||||||||||||
Redrive Participation | VARCHAR(60) | No | Reports whether Redrive protection is enabled or disabled for the current session. | ||||||||||||
User Dictionary Name | VARCHAR(128) | No | The attributes shown in this section are based on and supersede the corresponding older attributes:
The older attributes are retained for compatibility with existing applications. For details, see the topics beginning with Object Name and Title Data in HELP Reports. |
||||||||||||
User SQL Name | VARCHAR(644) | No | |||||||||||||
User UEscape | VARCHAR(1) | Yes | |||||||||||||
Account Dictionary Name | VARCHAR(128) | No | |||||||||||||
Account SQL Name | VARCHAR(644) | No | |||||||||||||
Account UEscape | VARCHAR(1) | Yes | |||||||||||||
Current Database Dictionary Name | VARCHAR(128) | No | |||||||||||||
Current Database SQL Name | VARCHAR(644) | No | |||||||||||||
Current Database UEscape | VARCHAR(1) | Yes | |||||||||||||
Current Role Dictionary Name | VARCHAR(128) | Yes | |||||||||||||
Current Role SQL Name | VARCHAR(644) | Yes | |||||||||||||
Current Role UEscape | VARCHAR(1) | Yes | |||||||||||||
Logon Account Dictionary Name | VARCHAR(128) | No | |||||||||||||
Logon Account SQL Name | VARCHAR(644) | No | |||||||||||||
Logon Account UEscape | VARCHAR(1) | Yes | |||||||||||||
Profile Dictionary Name | VARCHAR(128) | Yes | |||||||||||||
Profile SQL Name | VARCHAR(644) | Yes | |||||||||||||
Profile UEscape | VARCHAR(1) | Yes | |||||||||||||
Audit Trail Id Dictionary Name | VARCHAR(128) | No | |||||||||||||
Current Database SQL Name | VARCHAR(644) | No | |||||||||||||
Current Database UEscape | VARCHAR(1) | Yes | |||||||||||||
Audit Trail Id SQL Name | VARCHAR(644) | No | |||||||||||||
Audit Trail Id UEscape | VARCHAR(1) | Yes | |||||||||||||
Proxy User Dictionary Name | VARCHAR(128) | Yes | |||||||||||||
Proxy User SQL Name | VARCHAR(644) | Yes | |||||||||||||
Proxy User UEscape | VARCHAR(1) | Yes | |||||||||||||
Proxy Role Dictionary Name | VARCHAR(128) | Yes | |||||||||||||
Proxy Role SQL Name | VARCHAR(644) | Yes | |||||||||||||
Proxy Role UEscape | VARCHAR(1) | Yes | |||||||||||||
Constraint_ n Dictionary Name | VARCHAR(128) | Yes | |||||||||||||
Constraint_ n SQL Name | VARCHAR(644) | Yes | |||||||||||||
Constraint _ n_Name UEscape | VARCHAR(1) | Yes | |||||||||||||
Zone Name | VARCHAR(128) | N | Name of zone for the session. | ||||||||||||
SearchUIFDBPath | Yes | ||||||||||||||
Transaction QueryBand | VARCHAR(4096) | Yes | List of the query bands set for the transaction. | ||||||||||||
Session QueryBand | VARCHAR(4096) | Yes | List of the query bands set for the session. | ||||||||||||
Profile QueryBand | VARCHAR(4096) | Yes | List of the query bands set for the profile. | ||||||||||||
Unicode Pass Through | CHAR(1) | No | The Unicode Pass Through (UPT)
setting for the session:
|