17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

During a session, the account name may be changed. For the current account name of the session, see SessionInfoV[X].

For information about the possible values for the JournalFlag column, see "JournalFlag Column."

UserName

For this column, the SYSTEMUSERID is a system user name that tracks console utility activity such as table rebuild or Scandisk.

Possible Values for DefaultCharType

Value Description
1 Latin
2 Unicode
3 KanjiSJIS
4 Graphic
5 Kanji1

Possible Values for DefaultCollation

Value Description
A ASCII
E EBCDIC
H Host
M Multinational
C CharSet_Coll
J JIS_Coll

Possible Value for DefaultDataBase

If the default database is not defined in a CREATE/MODIFY USER statement, the DefaultDataBase column is the user space and NULL is returned.

At logon, the DefaultDataBase column may be superseded by a default account in a profile, if the user has a profile that specifies a default account.