APPLICATION ENCODING field (APPENSCH DECP value)

The APPENSCH DECP value determines the system's default application encoding scheme, which affects how Db2 interprets data coming into Db2.

For example, if your default application encoding scheme is set to 37, and your EBCDIC coded character is set to 500, Db2 converts all data coming into the system to 500 from 37 before using it. This includes, but is not limited to, SQL statement text and host variables.

Acceptable values:	ASCII, EBCDIC, UNICODE, or CCSID (1–65533)
Default:	EBCDIC
Update:	not recommended
`dsnhdecp`:	APPENSCH

The following statements set the value of the host variable and do not require the package to be bound into the plan:

    SET CURRENT PACKAGE SET = :HV ,
    SET :HV = CURRENT PACKAGE SET ,
    SET :HV = CURRENT PACKAGE PATH ,
    SET CURRENT PACKAGE PATH = :HV

The host variable uses the system's default application encoding scheme, even when the application is bound with the ENCODING(EBCDIC/UNICODE) bind option.

The default value, EBCDIC, causes Db2 to retain the behavior of previous versions of Db2. (Assume that all data is in the EBCDIC system CCSID.)