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:
|