Basic character conversions for DB2 in the z/OS conversion image

When you set up z/OS® Unicode Services for DB2®, you need to define a set of basic conversions between various CCSIDs.

To define these basic character conversions, add the basic conversion statements to high-level-qualifier.SCUNJCL(CUNJIUTL). These conversions are then added to the z/OS conversion image. Any duplicate statements are ignored.

In these CONVERSION statements, the variables have the following meanings:

your sccsid: The EBCDIC SBCS CCSID that is specified in your dsnhdecp module.
your asccsid: The ASCII SBCS CCSID that is specified in your dsnhdecp module.
your mccsid: The EBCDIC MBCS CCSID that is specified in your dsnhdecp module.
your amccsid: The ASCII MBCS CCSID that is specified in your dsnhdecp module.
your gccsid: The EBCDIC graphic CCSID that is specified in your dsnhdecp module.
your agccsid: The ASCII graphic CCSID that is specified in your dsnhdecp module.
client ccsid: The CCSID from a client that makes remote connections to this DB2 subsystem.

dsnhdecp is the user-specified application defaults module.

Basic CONVERSION statements

Specify the following conversion definitions between your ASCII and EBCDIC system CCSIDs and CCSIDs 367, 1208, and 1200:

CONVERSION your sccsid,00367,ER;
CONVERSION your sccsid,01200,ER;
CONVERSION your sccsid,01208,ER;
CONVERSION your sccsid,your asccsid,ER;
CONVERSION 00367,your sccsid,ER;
CONVERSION 00367,01200,ER;
CONVERSION 00367,01208,ER;
CONVERSION 00367,your asccsid,ER;
CONVERSION 01200,your sccsid,ER;
CONVERSION 01200,00367,ER;
CONVERSION 01200,01208,ER;
CONVERSION 01200,your asccsid,ER;
CONVERSION 01208,your sccsid,ER;
CONVERSION 01208,00367,ER;
CONVERSION 01208,01200,ER;
CONVERSION 01208,your asccsid,ER;
CONVERSION your asccsid,your sccsid,ER;
CONVERSION your asccsid,00367,ER;
CONVERSION your asccsid,01200,ER;
CONVERSION your asccsid,01208,ER;

If you use the samples that are provided with DB2, also define the following conversions:

CONVERSION 00037, 00367, ER;
CONVERSION 00037, 01200, ER;
CONVERSION 00037, 1208, ER;
CONVERSION 00367, 0037, ER;
CONVERSION 01200, 00037, ER;
CONVERSION 1208, 00037, ER;
CONVERSION 01047, 00367, ER;
CONVERSION 01047, 01200, ER;
CONVERSION 01047, 1208, ER;
CONVERSION 00367, 1047, ER;
CONVERSION 01200, 1047, ER;
CONVERSION 1208, 1047, ER;

Optional: For completeness, define the following conversions between CCSID 37 and CCSID 1047:
```
CONVERSION 00037, 01047, ER;
CONVERSION 001047, 0037, ER;
```

If your dsnhdecp module specifies an EBCDIC SBCS CCSID other than CCSID 37 or CCSID 1047, define the following conversions:

CONVERSION your sccsid, 00367, ER;
CONVERSION your sccsid, 01200, ER;
CONVERSION your sccsid, 01208, ER;
CONVERSION 00367, your sccsid, ER;
CONVERSION 01200, your sccsid, ER;
CONVERSION 01208, your sccsid, ER;

Optional: For completeness, define the following conversions between the EBCDIC SBCS CCSID that is defined in your dsnhdecp module and CCSIDs 37 and 1047.
```
CONVERSION 00037, your sccsid, ER;
CONVERSION your sccsid, 00037, ER;
CONVERSION 01047, your sccsid, ER;
CONVERSION your sccsid, 01047, ER;
```

If your DB2 subsystem uses mixed-byte or double-byte CCSIDs for EBCDIC and ASCII, specify the following conversions:

CONVERSION your sccsid,your mccsid,ER;
CONVERSION your sccsid,your amccsid,ER;
CONVERSION your mccsid,00367,ER;
CONVERSION your mccsid,01200,ER;
CONVERSION your mccsid,01208,ER;
CONVERSION your mccsid,your sccsid,ER;
CONVERSION your mccsid,your asccsid,ER;
CONVERSION your mccsid,your amccsid,ER;
CONVERSION your gccsid,00367,ER;
CONVERSION your gccsid,01200,ER;
CONVERSION your gccsid,01208,ER;
CONVERSION your gccsid,your agccsid,ER;
CONVERSION your asccsid,your mccsid,ER;
CONVERSION your asccsid,your amccsid,ER;
CONVERSION your amccsid,your mccsid,ER;
CONVERSION your amccsid,00367,ER;
CONVERSION your amccsid,01200,ER;
CONVERSION your amccsid,01208,ER;
CONVERSION your amccsid,your asccsid,ER;
CONVERSION your amccsid,your sccsid,ER;
CONVERSION your agccsid,your gccsid,ER;
CONVERSION your agccsid,00367,ER;
CONVERSION your agccsid,01200,ER;
CONVERSION your agccsid,01208,ER;
CONVERSION 00367,your mccsid,ER;
CONVERSION 00367,your gccsid,ER;
CONVERSION 00367,your amccsid,ER;
CONVERSION 00367,your agccsid),ER;
CONVERSION 01200,your mccsid,ER;
CONVERSION 01200,your gccsid),ER;
CONVERSION 01200,your amccsid,ER;
CONVERSION 01200,your agccsid),ER;
CONVERSION 01208,your mccsid,ER;
CONVERSION 01208,your gccsid,ER;
CONVERSION 01208,your amccsid,ER;
CONVERSION 01208,your agccsid,ER;

If your dsnhdecp module specifies an EBCDIC SBCS CCSID other than CCSID 37, specify the following conversions:

CONVERSION 00037,00367,ER;
CONVERSION 00037,00500,ER;
CONVERSION 00037,01047,ER;
CONVERSION 00037,01200,ER;
CONVERSION 00037,01208,ER;
CONVERSION 00037,(your asccsid),ER;
CONVERSION 00367,00037,ER;
CONVERSION 01200,00037,ER;
CONVERSION 01208,00037,ER;
CONVERSION your asccsid,00037,ER;

If your dsnhdecp module specifies an EBCDIC SBCS CCSID other than CCSID 500, specify the following conversions:

CONVERSION 00500,00037,ER;
CONVERSION 00500,00367,ER;
CONVERSION 00500,01047,ER;
CONVERSION 00500,01200,ER;
CONVERSION 00500,01208,ER;
CONVERSION 00500,your asccsid,ER;
CONVERSION 00367,00500,ER;
CONVERSION 01200,00500,ER;
CONVERSION 01208,00500,ER;
CONVERSION your asccsid,00500,ER;

If your dsnhdecp module specifies an EBCDIC SBCS CCSID other than CCSID 1047, specify the following conversions:

CONVERSION 01047,00037,ER;
CONVERSION 01047,00367,ER;
CONVERSION 01047,00500,ER;
CONVERSION 01047,01200,ER;
CONVERSION 01047,01208,ER;
CONVERSION 01047,your asccsid,ER;
CONVERSION 00367,01047,ER;
CONVERSION 01200,01047,ER;
CONVERSION 01208,01047,ER;
CONVERSION your asccsid,01047,ER;

Define the following conversions for each additional CCSID that is presented by clients that make remote connections to this DB2 subsystem:

CONVERSION client ccsid,00367,ER;
CONVERSION client ccsid,01200,ER;
CONVERSION client ccsid,01208,ER;
CONVERSION 00367,client ccsid,ER;
CONVERSION 01200,client ccsid,ER;
CONVERSION 01208,client ccsid,ER;