SORT-MERGE/XL General User's Guide
> Chapter 6 SORT-MERGE/XL CommandsSHOW |
||||||||||||||||||
|
SYNTAX{S[EQUENCE][,O[FFLINE} {T[ABLE][,O[FFLINE } >SH[OW] { } {NOS[EQUENCE] } {NOT[ABLE] } PARAMETERS
EXAMPLESThe following examples show how to display collating sequences and transaction tables. Displaying the ASCII Collating SequenceTo 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 SequenceTo 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 SequencesAfter 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 >ALTSEQ 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 ParameterEntering 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 DISCUSSIONNone.
|