HP 3000 Manuals HP 3000 Manuals
SHOW
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.
Table 6-0. (cont.)
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
(c) 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
(c) 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
(c) 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`~~LTSEQ 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
(c) 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
(c) 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.