Specifying conversion procedures
You can specify a conversion procedure that converts characters from one coded character set to another coded character set.
About this task
Procedure
To specify a conversion procedure:
Insert a row into the SYSIBM.SYSSTRINGS catalog table. The row must contain values for the following columns:
- INCCSID
- The coded character set identifier (CCSID) of the source string.
- OUTCCSID
- The CCSID of the converted string.
- TRANSTYPE
- The nature of the conversion. Values can be:
- GG
- ASCII GRAPHIC to EBCDIC GRAPHIC
- MM
- EBCDIC MIXED to EBCDIC MIXED
- MP
- EBCDIC MIXED to ASCII MIXED
- MS
- EBCDIC MIXED to EBCDIC SBCS
- PM
- ASCII MIXED to EBCDIC MIXED
- PP
- ASCII MIXED to ASCII MIXED
- PS
- ASCII MIXED to EBCDIC SBCS
- SM
- EBCDIC SBCS to EBCDIC MIXED
- SP
- SBCS (ASCII or EBCDIC) to ASCII MIXED
- SS
- EBCDIC SBCS to EBCDIC SBCS
- TRANSPROC
- The name of your conversion procedure.
- IBMREQD
- Must be N.
DB2® does not use the following columns, but checks them for the allowable values listed. Values you insert can be used by your routine in any way. If you insert no value in one of these columns, DB2 inserts the default value listed.
- ERRORBYTE
- Any character, or null. The default is null.
- SUBBYTE
- Any character not equal to the value of ERRORBYTE, or null. The default is null.
- TRANSTAB
- Any character string of length 256 or the empty string. The default is an empty string.