Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.