 |
» |
|
|
|
The >SHOW command displays the collating sequence or the translation table. SYNTAX |  |
{S[EQUENCE][,O[FFLINE}
{T[ABLE][,O[FFLINE }
>SH[OW] { }
{NOS[EQUENCE] }
{NOT[ABLE] }
|
PARAMETERS |  |
S[EQUENCE] | The S[EQUENCE] parameter displays the collating sequence. This sequence is determined by the first 128 characters of the ASCII code, unless preceded by an >ALTSEQ command or a >DATA command with the EBCDIC sequence parameter. If the OFFLINE parameter is not issued, the sequence is displayed on the terminal. (If the OFFLINE parameter is issued, the sequence is printed on the line printer.) The display consists of the representation of each character in the relative order in which the collating sequence sorts (or merges) the records. Characters with the same ordinal values are adjoined by equal sign(s). Once specified in the >SHOW command, it is displayed after each subsequent >ALTSEQ command during a particular sort or merge operation until you specify NOSEQUENCE. OFFLINE activates the formal file designator DISPLOUT, with the line printer as the default device type (DEV=LP). Alternatively, you can store the contents of the sequence on a disc (or tape) file by appending DEV=DISC (or TAPE) to the file equation. | T[ABLE] | This parameter displays the translation table. After defining your special collating sequence, you may want to look at the table and the changes that occur in it. The table is helpful if you call SORT/XL (or MERGE/XL) from a program. (Refer to the SORT-MERGE/XL Programmers Guide (32650-90080) for additional information.) The translation table is organized according to the ASCII code decimal values of the characters. You should look at the position defined by the ASCII code decimal value to determine the ordinal value of a particular character. The table displays graphic characters each equated to its ordinal value, and the ordinal values of the characters that do not have graphic representation. Like the SEQUENCE option, the translation table is displayed after each >ALTSEQ command. The >SHOW TABLE command displays the table (in decimal) on the terminal. | NOS[EQUENCE] | Suppresses the display of the collating sequence in a particular SORT/XL (or MERGE/XL) operation. However, you can again get the display by specifying SEQUENCE. | NOT[ABLE] | Suppresses the display of the translation table until you enter a >SHOW TABLE command. |
EXAMPLES |  |
The following examples show how to display collating sequences and transaction tables. Displaying the ASCII Collating Sequence |  |
To display the standard ASCII collating sequence to your terminal enter >DATA IS ASCII, SEQUENCE IS ASCII followed by >SHOW SEQUENCE. This command generates the ASCII collating sequence based on the first 128 characters of the ASCII code. If you also enter OFFLINE after >SHOW SEQUENCE, the sequence is printed on the line printer.
:SORT
HP32214A.01.00 SORT/3000 THU, JUN 4, 1987, 10:25 AM
© HEWLETT-PACKARD CO. 1986
>DATA IS ASCII, SEQUENCE IS ASCII
>SHOW SEQUENCE
nul soh stx etx eot enq ack bel bs ht lf vt ff cr so si
dle dc1 dc2 dc3 dc4 nak syn etb can em sub esc fs gs rs us
sp ! " # $ % & ' ( ) * + , - . /
0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O
P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o
p q r s t u v w x y z { | } ~ del
|
Displaying the EBCDIC Collating Sequence |  |
To display the EBCDIC collating sequence, enter the EBCDIC parameter of the >DATA command.
:SORT
HP32214A.01.00 SORT/3000 THU, JUN 4, 1987, 10:30 AM
© HEWLETT-PACKARD CO. 1986
>DATA IS ASCII, SEQUENCE IS EBCDIC
>SHOW SEQUENCE
nul soh stx etx ht del vt ff cr so si dle dc1 dc2 dc3 bs
can em fs gs rs us lf etb esc enq ack bel syn eot dc4 nak
sub sp [ . > ( + ! & ] $ * ) ; ^ -
/ @ , % _ > ? ` : # @ ' = " a b
c d e f g h i j k l m n o p q r
~ s t u v w x y z { A B C D E F
G H I } J K L M N O P Q R \ S T
U V W X Y Z 0 1 2 3 4 5 6 7 8 9
|
Displaying Recurring Collating Sequences |  |
After you specify SHOW SEQUENCE in the >SHOW command, the collating sequence is displayed after each subsequent >ALTSEQ command until you specify the NOSEQUENCE parameter.
:SORT
HP32214A.01.00 SORT/3000 THU, JUN 4, 1987, 10:35 AM
© HEWLETT-PACKARD CO. 1986
>DATA IS ASCII, SEQUENCE IS ASCII
>SHOW SEQUENCE
nul soh stx etx eot enq ack bel bs ht lf vt ff cr so si
dle dc1 dc2 dc3 dc4 nak syn etb can em sub esc fs gs rs us
sp ! " # $ % & ' ( ) * + , - . /
0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A B C D E F G H I J K L M N O
P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o
p q r s t u v w x y z { | } ~ del
>`A`~~ MERGE "A-C" WITH "D-L" ''
nul soh stx etx eot enq ack bel bs ht lf vt ff cr so si
dle dc1 dc2 dc3 dc4 nak syn etb can em sub esc fs gs rs us
sp ! " # $ % & ' ( ) * + , - . /
0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A D B E C F G H I J K L M N O
P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o
p q r s t u v w x y z { | } ~ del
>ALTSEQ "A" = "B"
nul soh stx etx eot enq ack bel bs ht lf vt ff cr so si
dle dc1 dc2 dc3 dc4 nak syn etb can em sub esc fs gs rs us
sp ! " # $ % & ' ( ) * + , - . /
0 1 2 3 4 5 6 7 8 9 : ; < = > ?
@ A= D B E C F G H I J K L M N O
P Q R S T U V W X Y Z [ \ ] ^ _
` a b c d e f g h i j k l m n o
p q r s t u v w x y z { | } ~ del
|
>SHOW NOSEQUENCE
>ALTSEQ MERGE "a-c" WITH "A-C"
|
Using the >SHOW Command TABLE Parameter |  |
Entering the >SHOW TABLE command, following the >DATA command, generates the translation table either to your terminal or to the printer if you designate OFFLINE. The standard ASCII translation table shows each character, in ascending order, and its ordinal (decimal) value.
:SORT
HP32214A.01.00 SORT/3000 THU, JUN 4, 1987, 10:40 AM
© HEWLETT-PACKARD CO. 1986
>DATA IS ASCII, SEQUENCE IS ASCII
>ALTSEQ "B" = "A"
>SHOW TABLE
:RUN SORT.PUB.SYS
HP32214C.02.05 SORT/3000 SUN, JUL 19, 1987, 10:55 AM
© HEWLETT-PACKARD CO. 1986
>DATA A SEQ A
>A "B" = "A"
>SHOW TABLE
TABLE OF ORDINAL VALUE ASSIGNED TO EACH CHARACTER.
! 0 ! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! 7 ! 8 ! 9
----+------+------+------+------+------+------+------+------+------+------
0 ! 0 ! 1 ! 2 ! 3 ! 4 ! 5 ! 6 ! 7 ! 8 ! 9 !
1 ! 10 ! 11 ! 12 ! 13 ! 14 ! 15 ! 16 ! 17 ! 18 ! 19 !
2 ! 20 ! 21 ! 22 ! 23 ! 24 ! 25 ! 26 ! 27 ! 28 ! 29 !
3 ! 30 ! 31 !sp=32 !!= 33 !"= 34 !#= 35 !$= 36 !%= 36 !&= 38 !'= 39 !
4 !(= 40 !)= 41 !*= 42 !+= 43 !,= 44 !-= 45 !.= 46 !/= 47 !0= 48 !1= 49 !
5 !2= 50 !3= 51 !4= 52 !5= 53 !6= 54 !7= 55 !8= 56 !9= 57 !:= 58 !;= 59 !
6 !<= 60 !== 61 !>= 62 !?= 63 !@= 64 !A= 65 !B= 65 !C= 67 !D= 68 !E= 69 !
7 !F= 70 !G= 71 !H= 72 !I= 73 !J= 74 !K= 75 !L= 76 !M= 77 !N= 78 !O= 79 !
8 !P= 80 !Q= 81 !R= 82 !S= 83 !T= 84 !U= 85 !V= 86 !W= 87 !X= 88 !Y= 89 !
9 !Z= 90 ![= 91 !\= 92 !]= 93 !^= 94 !_= 95 !`= 96 !a= 97 !b= 98 !c= 99 !
10 !d=100 !e=101 !f=102 !g=103 !h=104 !i=105 !j=106 !k=107 !l=108 !m=109 !
11 !n=110 !o=111 !p=112 !q=113 !r=114 !s=115 !t=116 !u=117 !v=118 !w=119 !
12 !x=120 !y=121 !z=122 !{=123 !|=124 !}=125 !~=126 ! =127 ! 128 ! 129 !
13 ! 130 ! 131 ! 132 ! 133 ! 134 ! 135 ! 136 ! 137 ! 138 ! 139 !
14 ! 140 ! 141 ! 142 ! 143 ! 144 ! 145 ! 146 ! 147 ! 148 ! 149 !
15 ! 150 ! 151 ! 152 ! 153 ! 154 ! 155 ! 156 ! 157 ! 158 ! 159 !
16 ! 160 ! 161 ! 162 ! 163 ! 164 ! 165 ! 166 ! 167 ! 168 ! 169 !
17 ! 170 ! 171 ! 172 ! 173 ! 174 ! 175 ! 176 ! 177 ! 178 ! 179 !
18 ! 180 ! 181 ! 182 ! 183 ! 184 ! 185 ! 186 ! 187 ! 188 ! 189 !
19 ! 190 ! 191 ! 192 ! 193 ! 194 ! 195 ! 196 ! 197 ! 198 ! 199 !
20 ! 200 ! 201 ! 202 ! 203 ! 204 ! 205 ! 206 ! 207 ! 208 ! 209 !
21 ! 210 ! 211 ! 212 ! 213 ! 214 ! 215 ! 216 ! 217 ! 218 ! 219 !
22 ! 220 ! 221 ! 222 ! 223 ! 224 ! 225 ! 226 ! 227 ! 228 ! 229 !
23 ! 230 ! 231 ! 232 ! 233 ! 234 ! 235 ! 236 ! 237 ! 238 ! 239 !
24 ! 240 ! 241 ! 242 ! 243 ! 244 ! 245 ! 246 ! 247 ! 248 ! 249 !
25 ! 250 ! 251 ! 252 ! 253 ! 254 ! 255 !
WHEN PASSED TO SORTINIT, THE TABLE ABOVE IS PRECEDED BY TWO BYTES.
THESE FIRST TWO BYTES CONTAIN A FLAG BYTE OF %000 AND A LENGTH BYTE OF
%377 RESPECTIVELY.
|
Columns are labeled 0, 1, 2, through 9, and rows are labelled 0, 1, 2, through 25. The table is used by first reading down the leftmost column and then across from left to right. If you want to know the current ordinal value of B (whose ASCII code decimal value is 66), read down the table to locate the row labelled 6. Then read across until you reach the column with the heading 6. The value (65) contained in this position (6,6) identifies the location of the character B in the altered collating sequence. Use the OFFLINE parameter to send the contents of the table to the line printer, disc, or tape. In this case, the
table is created in three forms. During programmatic usage of SORT/XL or MERGE/XL, this information is edited and inserted into a program and then copied into the >ALTSEQ array passed to SORT/XL or MERGE/XL. ADDITIONAL DISCUSSION |  |
None.
|