Loading a Custom Client Character Set - Advanced SQL Engine - Teradata Database

You must load a character set before you can activate it for use.

1. Log on to the Teradata Database as a user with INSERT privileges on database DBC.
2. Use the INSERT statement to load each needed character set into the DBC.CharTranslationsV view, using a BTEQ batch file or other method.

   Ensure that the client configuration matches the translation entry and table just created.

   There is no limit on the number of character sets you can load onto your system, but no more than 16 character sets can be active at a time.

Example Load Script

This example shows a BTEQ batch job used to insert a row defining the translation codes for a Finnish/Swedish character set. The external hexadecimal codes are EBCDIC and agree with Character Sequence Number 24 for an IBM 3270 Control Unit displaying to an IBM 3270 Information Display System.

/*****************************************************************/
/* This is the Finnish/Swedish Character Set Codes for IBM 3270  */
/* information display system. The IBM manuals title “IBM 3270   */
/* Information Display System. 3270 Control Unit“ and “IBM 3270  */
/* Information Display System. Character Set Reference“.         */
/* Document numbers GA23-0065-6 and GA27-2837-9 correspondingly. */
/* The sequence number for this character set is 24 - see 2-55   */
/* of GA23-0065-6 and 10-17 and 10-45 of GA27-2837-9. Here is    */
/* the map between DBC and IBM character codes:                  */
/*                                                               */
/*     Character Name                       DBC   IBM            */
/*                                          HEX   HEX            */
/*                                                               */
/*     Lowercase a with umlaut (diaresis)...E4    C0             */
/*     Uppercase A with umlaut (diaresis)...C4    7B             */
/*     Lowercase a with ring................E5    D0             */
/*     Uppercase A with ring................C5    5B             */
/*     Lowercase e with acute accent........E9    79             */
/*     Uppercase E with acute accent........C9    E0             */
/*     Lowercase o with umlaut (diaresis)...F6    05             */
/*     Uppercase O with umlaut (diaresis)...D6    7C             */
/*     Lowercase u with umlaut (diaresis)...FC    A1             */
/*****************************************************************/
INSERT INTO DBC.CharTranslationsV 
( CharSetName
, CharSetId 
, InstallFlag 
, E2I
, E2IUp
, I2E
, I2EUp )
VALUES
( ’SWEDISH_EBCDIC’
, 71   
, ’Y’
/* TranslateIn.  External -> Internal      */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F         */
, ’00010203A8F6A97FD1D2D30B0C0D0E0F’xb/* 0 */
||’10111213D4D508401819D7D81C1D1E1F’xb/* 1 */
||’7DE6D9E7E80A171B60F0F1F2F3050607’xb/* 2 */
||’F4F51609F75CF804F9E2E37B1415E01A’xb/* 3 */
||’208182838485868788898B2E3C282B8D’xb/* 4 */
||’2691929394959697989921C52A293B5E’xb/* 5 */
||’2D2F9B9DA2A3A4A5A6A77C2C255F3E3F’xb/* 6 */
||’C1C2C32324C6C7C87EE93AC4D6273D22’xb/* 7 */
||’806162636465666768698AC08CAD8E8F’xb/* 8 */
||’906A6B6C6D6E6F7071729AD09CBD9E9F’xb/* 9 */
||’A0FC737475767778797AAAABAC5BAEAF’xb/* A */
||’B0B1B2B3B4B5B6B7B8B9BABBBC5DBEBF’xb/* B */
||’E4414243444546474849CACBCCCDCECF’xb/* C */
||’E54A4B4C4D4E4F505152DADBDCDDDEDF’xb/* D */
||’C9E1535455565758595AEAEBECEDEEEF’xb/* E */
||’30313233343536373839FAFBA1FDFEFF’xb/* F */
/* TranslateInUp.  External -> Internal    */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F         */
, ’00010203A8D6A97FD1D2D30B0C0D0E0F’xb/* 0 */
||’10111213D4D508401819D7D81C1D1E1F’xb/* 1 */
||’7DE6D9E7E80A171B60F0F1F2F3050607’xb/* 2 */
||’F4F51609F75CF804F9E2E37B1415E01A’xb/* 3 */
||’208182838485868788898B2E3C282B8D’xb/* 4 */
||’2691929394959697989921C52A293B5E’xb/* 5 */
||’2D2F9B9DA2A3A4A5A6A77C2C255F3E3F’xb/* 6 */
||’C1C2C32324C6C7C87EC93AC4D6273D22’xb/* 7 */
||’804142434445464748498AC08CAD8E8F’xb/* 8 */
||’904A4B4C4D4E4F5051529AD09CBD9E9F’xb/* 9 */
||’A0FC535455565758595AAAABAC5BAEAF’xb/* A */
||’B0B1B2B3B4B5B6B7B8B9BABBBC5DBEBF’xb/* B */
||’C4414243444546474849CACBCCCDCECF’xb/* C */
||’C54A4B4C4D4E4F505152DADBDCDDDEDF’xb/* D */
||’C9E1535455565758595AEAEBECEDEEEF’xb/* E */
||’30313233343536373839FAFBA1FDFEFF’xb/* F */
/* TranslateOut. Internal -> External      */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F         */
, ’00010203372D2E2F1633250B0C0D0E0F’xb/* 0 */
||’101112133C3D322618193F271C1D1E1F’xb/* 1 */
||’405A7F73746C507D4D5D5C4E6B604B61’xb/* 2 */
||’F0F1F2F3F4F5F6F7F8F97A5E4C7E6E6F’xb/* 3 */
||’17C1C2C3C4C5C6C7C8C9D1D2D3D4D5D6’xb/* 4 */
||’D7D8D9E2E3E4E5E6E7E8E9AD35BD5F6D’xb/* 5 */
||’28818283848586878889919293949596’xb/* 6 */
||’979899A2A3A4A5A6A7A8A93B6A207807’xb/* 7 */
||’804142434445464748498A4A8C4F8E8F’xb/* 8 */
||’905152535455565758599A629C639E9F’xb/* 9 */
||’A0FC6465666768690406AAABAC8DAEAF’xb/* A */
||’B0B1B2B3B4B5B6B7B8B9BABBBC9DBEBF’xb/* B */
||’8B7071727B5B757677E0CACBCCCDCECF’xb/* C */
||’9B08090A14157C1A1B22DADBDCDDDEDF’xb/* D */
||’3EE1393AC0D021232479EAEBECEDEEEF’xb/* E */
||’292A2B2C303105343638FAFBA1FDFEFF’xb/* F */
/* TranslateOutUp. Internal -> External    */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F         */
, ’00010203372D2E2F1633250B0C0D0E0F’xb/* 0 */
||’101112133C3D322618193F271C1D1E1F’xb/* 1 */
||’405A7F73746C507D4D5D5C4E6B604B61’xb/* 2 */
||’F0F1F2F3F4F5F6F7F8F97A5E4C7E6E6F’xb/* 3 */
||’17C1C2C3C4C5C6C7C8C9D1D2D3D4D5D6’xb/* 4 */
||’D7D8D9E2E3E4E5E6E7E8E9AD35BD5F6D’xb/* 5 */
||’28C1C2C3C4C5C6C7C8C9D1D2D3D4D5D6’xb/* 6 */
||’D7D8D9E2E3E4E5E6E7E8E93B6A207807’xb/* 7 */
||’804142434445464748498A4A8C4F8E8F’xb/* 8 */
||’905152535455565758599A629C639E9F’xb/* 9 */
||’A0FC6465666768690406AAABAC8DAEAF’xb/* A */
||’B0B1B2B3B4B5B6B7B8B9BABBBC9DBEBF’xb/* B */
||’8B7071727B5B757677E0CACBCCCDCECF’xb/* C */
||’9B08090A14157C1A1B22DADBDCDDDEDF’xb/* D */
||’3EE1393A7B5B212324E0EAEBECEDEEEF’xb/* E */
||’292A2B2C30317C343638FAFBA1FDFEFF’xb/* F */
);