 |
» |
|
|
 |
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 |
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.
|