Translation

The Translation tab allows you to specify translation options.

Translate CCSID 65535
Specifies whether translation of ASCII data stored in columns on the system with an explicit CCSID of 65535 is disabled or enabled.

A CCSID (coded character set identifier) is a two-byte binary identifier referred to by the Character Data Representation Architecture (CDRA). A CCSID is a short-form identifier that is used as the preferred alternative to the long-form identifier (also defined by CDRA). The range of CCSID values is 0(0000) to 65535(FFFF).

Interpret hexadecimal constants as binary data
This value is used to select the data type used by hex constants in SQL expression. The binary setting indicates that hex contants will use the BINARY data type, which was new in V5R3. The character setting indicates that hex contants will use the CHARACTER FOR BIT DATA data type. The default setting is character.