SCHEBCDIC935_2IJ - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Product
Teradata Tools and Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
zwv1608578409227.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
Product Category
Teradata Tools and Utilities

The character set on the database named SCHEBCDIC935_2IJ is intended as an extended EBCDIC character set consisting of both one and two-bytes per character. Architecturally, the EBCDIC encoding scheme consists of 256 possible values (codepoints) represented as hexadecimal values in the range X'00' to X'FF'

To support more than 256 codepoints, the EBCDIC encoding scheme is extended by defining the Shift-out control character to switch from one byte per character to two bytes per character until the Shift-in control character is encountered. The first byte of codepoints between the Shift-out and Shift-in control characters is always between X'41' and X'FE'. Currently, the second byte is also between X'41' and X'FE'. The X'4040' codepoint is defined as the Double-byte Space character. No double-byte control characters exist. The double-byte characters are not described.

Single-byte Teradata SCHEBCDIC935_2IJ Codepage
  x0 x1 x2 x3 x4 x5 x6 x7 x8 x9 xA xB xC xD xE xF
0x NUL SOH STX ETX ST HT SSA DEL EPA RI SS2 VT FF CR SO SI
1x DLE DC1 DC2 DC3 OSC NEL BS ESA CAN EM PU2 SS3 IS4 IS3 IS2 IS1
2x UC1 UC2 BPH NBH UC3 LF ETB ESC HTS HTJ VTS PLD PLU ENQ ACK BEL
3x DCS PU1 SYN STS CCH MW SPA EOT SOS UC4 SCI CSI DC4 NAK PM  
4x SP                   £ · < ( + |
5x &                   ! ¥ * ) ; ¬
6x - /                 ¦ ¸ % _ > ?
7x                   ` : # @ ' = "
8x   a b c d e f g h i            
9x   j k l m n o p q r            
Ax ~ s t u v w x y z            
Bx ^   \               [ ]        
Cx { A B C D E F G H I            
Dx } J K L M N O P Q R            
Ex $   S T U V W X Y Z            
Fx 0 1 2 3 4 5 6 7 8 9           APC
                                 
Control character codepoints                          
Reserved codepoints                            

The database rejects character data containing any single or double byte reserved codepoint and does not identify which invalid codepoint was present.

While graphic characters adhere to the standard definition for IBM code page 00836, the control characters and Eight Ones character do not because non-EBCDIC control characters appear in the range reserved for control characters, all common control characters are not present, and a non-EBCDIC control character replaces the Eight Ones character.

While IBM GCGIDs differentiate the Yen (SC050000) from the Yuan (SC120000) and here codepoint X'5B' is the Yuan, Unicode, and the database do not and use U+00A5 for both.

The database defines the Overline character for KANJIEBCDIC5026_0I, KANJIEBCDIC5035_0I, KATAKANAEBCDIC, and SCHEBCDIC935_2IJ differently than for the other character sets. If this character is sent to the database using a character set in one group but received from the database using a character set in the other group, the codepoint will change.

No special processing is performed by the database for control characters, except for Shift Out and Shift In, which switch to and from double-byte codepoints. The non-EBCDIC control characters Single Shift Two and Single Shift Three imply nothing about subsequent codepoints.