ENCODINGCHARSET - TARA/ABU

The ENCODINGCHARSET parameter adds support for the UTF-16 encoding character sets to Teradata ARC. Use the ENCODINGCHARSET, ENNAME, or EN parameters when specifying the UTF-16 encoding character set. Use the ENCODINGCHARSET parameter when invoking the ARCMAIN program at startup.

Note: The CHARSETNAME parameter set to UTF8 must always accompany the UTF16 encoding character set parameter because it is the only valid character set name used in the interaction of Teradata ARC with DBS.

ARCMAIN has the ability to handle UTF-16 strings when interacting with its interfaces. These interfaces could be input files or output files. The data within parcels (data structures) and SQL strings sent to the DBS is converted from the UTF-16 format to the DBS format. The data received from the DBS is converted from the DBS format to UTF-16 format. Currently the DBS only supports the UTF-8 format.

Thus ARCMAIN is able to:

read input files encoded using UTF-16

write output files encoded using UTF-16

Two restrictions apply to the encoding character set parameter:

The only allowed value for the ENOCDINGCHARSET parameter is UTF16. ARC does not allow any other value to be specified here.

The only valid value for the CHARSETNAME parameter is UTF8 as the Teradata ARC interaction with DBS must occur in another unicode compatible charset, namely UTF8

arcmain ENCODINGCHARSET=UTF16 CHARSETNAME=UTF8 < arc.in

Where the arc.in file contains one or more archive/recovery control language statements.