INFO: Determining code pages used by DataGate/400 character translation

The information in this article applies to:

DataGate/400, Version 4.2 and higher
AS/400

SUMMARY:

DataGate/400 depends upon the AS/400 for translation table support. If there is no translation tables for the given combination of client and server code pages, then a faulty translation will result.

MORE INFORMATION:

NOTE: Please work with your System Administrator or IBM while working with the AS/400.

DataGate/400 obtains the code page of the PC from the PC via the connect protocol, and the PC obtains this code page from the Win32 API (the PC's code page is not configurable, it depends on the version of Windows).

DataGate/400 obtains the code page of the job its running in via the QSYRUSRI API. This returns the CCSID associated with the user profile of the AS/400 job (the connecting user). The user profile may have the "*SYSVAL" value for its CCSID, in which case, DataGate/400 proceeds to obtain the value of the QCCSID system value.

The most common problem is that either the user profile is set up to use the wrong (or an unsupported) CCSID, or the system value is wrong. Less likely but a real possibility is that this particular AS/400 does not support one of the code page values. For example, if there is no translation table on the AS/400 for the PC code page value. In this case, the system default ASCII / EBCDIC translation tables are used (QASCII / QEBCDIC), resulting in the somewhat faulty translations.

Use DSPUSRPRF/CHGUSRPRF to display/change the CCSID of the user profile first. Then, if necessary, use DSPSYSVAL/CHGSYSVAL to display/change the QCCSID system value.

You can also review the CCSID of a DataGate/400 end user job (See Figure 1)

Figure 1