The DBC.HostsInfoV displays default character set assignments by HostID.
Example DBC.HostsInfoV
SELECT * FROM DBC.HostsInfoV;
*** Query completed. Nine rows found. 3 columns returned. *** Time was 2.14 seconds. LogicalHostId HostName DefaultCharSet ------------- -------- ----------------------------- 1076 UTF8_LAN UTF8
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 (channel connection) or network, 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:
|