16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.