DB2DEF_ENCODING={A|
E|U}

A.
ASCII encoding.
E
.
EBCDIC encoding.
U.
Unicode encoding.

An encoding scheme might not be specified in the SYSIBM.SYSDATABASE table as a result of multiple DB2 migrations.

In general, specify the encoding that is defined for DB2 in the

DEF ENCODING SCHEME

field on the application programming defaults panel,

DSNTIPF

. However, if DSNTIPF specifies 65534 for the mixed code page, edit the DB2CODEPAGE statement to set the

mixed_ccsid

value of the comparable ASCII, EBCDIC, or Unicode parameter to 037. The 037 value is required for PowerExchange to read the DB2 catalog tables.

For example, if you use the default value of E for the DB2DEF_ENCODING statement and the DSNTIPF panel specifies 65534 for the EBCDIC mixed code page, specify 037 as the last positional subparameter of the EBCDIC_CCSID parameter in the DB2CODEPAGE statement:

EBCDIC_CCSID=(
sbcs_ccsid,
graphic_ccsid,037)