SYSIBM.SYSSTRINGS catalog table
The Db2 catalog table SYSIBM.SYSSTRINGS contains information about valid character conversion definitions. Each row of SYSSTRINGS contains information about the conversion of character strings from one CCSID to another CCSID. Db2 uses the conversion tables that are identified by these rows.
Db2 automatically performs any required conversions from the CCSID that is identified by the INCCSID column to the CCSID that is identified by the OUTCCSID column.
Restriction: You cannot update or delete rows that are provided by IBM®. These rows are identified by a value of Y in the IBMREQD column. However, you can add another row with the same pair of CCSIDs. Rows that you add are identified by a value of N in the IBMREQD column. If two rows exist for the same pair of CCSIDs (an IBM-supplied row and a row that you added) Db2 uses your row for the conversion.
In some cases, rows with IBMREQD = N are not rows that you added. Sometimes, these rows have been supplied by IBM Software Support. For an example of adding such rows, look at job DSNTEJ1T.
Example
Assume that the SYSSTRINGS table includes the following rows: INCCSID OUTCCSID TRANSTYPE ERRORBYTE SUBBYTE TRANSPROC IBMREQD TRANSTAB
---------+---------+---------+---------+---------+---------+---------+---------+-------------
500 37 SS --------- ------- Y ...........
37 500 SS --------- ------- Y ...........
948 37 PS 3E 3F Y ........... - The first row describes the conversion from CCSID 500 to CCSID 37.
- The second row describes the conversion from CCSID 37 to CCSID 500.
- The third row describes a conversion from CCSID 948 to CCSID 37 in which X'3E' is used as an error indicator and X'3F' is used as a substitute code point.
Tip: Use the HEX function to display the values of the ERRORBYTE, SUBBYTE, and TRANSTAB columns.
