Establishing a Character Set - Teradata Tools and Utilities

Teradata® Archive/Recovery Utility Reference

Product
Teradata Tools and Utilities
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-06-05
dita:mapPath
fac1527114221922.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
Product Category
Teradata Tools and Utilities

Establishing a character set for a particular archive/recovery operation is supported. However, after the character set is established, do not attempt to change it while Teradata ARC is executing an operation. When a character set is established, that character set accepts only Teradata ARC statements input in that character set.

Establish a character set in one of the following ways:

  • At startup, invoke a parameter in JCL from z/OS. This user-specified character set overrides all other character sets previously specified or placed in default.
  • Specify a character set value in the HSHSPB parameter module for IBM mainframes. This takes second precedence.
  • If a character set is not user-specified or specified in HSHSPB, the default is the value in the system table, database DBC.Hosts.

If relying on the database DBC.Hosts table for the default character set name, ensure that the initial logon from the channel-attached side is in EBCDIC. Otherwise, Teradata ARC does not know the default character set before logon.

Example: Establishing a Character Set

On z/OS, this JCL invokes ARCMAIN:

  //ARCCPY EXEC PGM=ARCMAIN,PARM=’SESSIONS=8 CHARSETNAME=KATAKANAEBCDIC’