16.10 - About the DBC.HostsInfoV View - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

The DBC.HostsInfoV displays default character set assignments by HostID. See Assigning Default Client Character Sets in DBC.HostsInfoV.

Example DBC.HostsInfoV

SELECT * FROM DBC.HostsInfoV;
*** Query completed. Nine rows found. 3 columns returned.
*** Time was 2.14 seconds.
   LogicalHostId HostName DefaultCharSet 
   ------------- -------- -----------------------------
             136 VM       SWEDISH_EBCDIC
             137 VM       German_EBCDIC
             138 VM       Spanish_EBCDIC
             139 VM       French_EBCDIC
             140 VM       Italian_EBCDIC
             141 VM       Norwegian_EBCDIC
             142 VM       EBCDIC037_0E
            1076 PC_LAN   LATIN1_0A

Explanation of Example DBC.HostsInfoV

Field Data Type Comment
LogicalHostId SMALLINT Identifies the client connection (mainframe or LAN) for which a default character set is being defined.

This value must be the same as the identifier established for this connection by the hardware configuration data. For details on how to determine the value, see Finding the LogicalHostId.

HostName VARCHAR(128) An arbitrary, user-assigned name for this host, for example, Mainframe1, TokyoLAN, or RetailWebsite.
DefaultCharSet VARCHAR(128) The name of the session character set to be used by default when passing data to and from the clients in the host group.

The value in this column may be:

  • A permanently enabled client character set

    EDCDIC

    ASCII

    UTF8

    UTF16

  • A client character set name from the CharSetName column in DBC.CharTranslationsV for which the Install Flag is set to Y.