Correct CCSID to convert codes set between DB2s

Michale Yu

Correct CCSID to convert codes set between DB2s
Hello list:

I am trying to connect with DB2 for OS 390 with DB2 CONNECT ENTERPRISE
EDITION running on platform NT. The probelm is :

I have connected to DB2 for OS 390 successfully through SNA(VTAM), but when
I tried to execute a SQL
statement to retrieve data from a table in DB2 for OS 390 from COMMAND
CENTER of DB2 CONNECT
on NT, I got error message code -332.

I have checked information of -332 in IBM DB2 MESSAGE & CODE where express
below:

-332 SYSSTRINGS DOES NOT DEFINE A TRANSLATION FROM CCSID ccsid TO ccsid
Explanation: The operation required a translation of a string to a
different coded character set, but the
particular translation is not described in the SYSSTRINGS catalog table. The
first 'ccsid' identifies the coded character set of the string and the
second 'ccsid' identifies the coded character set to which it must be
translated.
System Action: The statement cannot be executed.
Programmer Response: If the CCSIDs are correct, the only corrective action
is to provide for the
translation by inserting a row into SYSSTRINGS. For an SBCS translation, the
row must contain a translate table or the name of a user-provided translate
procedure. For a DBCS translation, the row must contain the name of a
user-provided translate procedure. Refer to Chapter 3 of SQL Reference for
more information on coded character set.
Destination: 57017

The CCSID I have defined in DB2 for OS 390 is 937(traditional chinese), the
code page on NT is 1386,
in SYSIBM.SYSSTRINGS table, there is not correct row to define this
conversion, and I have inserted a row into SYSIBM.SYSSTRINGS table as below:
INCCSID=1386,OUTCCSID=937,TRANSTYPE=PM,IBMREQD=N,but I got
the same result.

Is there anyone has finished the same work, could anyone give me any help.