Re: Sorting Hex Data - ISPF or Batch
My way - http://www.ktomiak.biz/ORG/STUFF/tips/REXX036.html Adding a column for non-displayable data was not an option I wanted to do. Nor was writing my own specialized sort. I also submitted a requirement through the SHARE ISPF Project to have ISPF do something as simple as this. How long ago was that, I forget. On Thu, 6 Mar 2008 19:33:43 +0200, Binyamin Dissen [EMAIL PROTECTED] wrote: On Thu, 6 Mar 2008 11:31:11 -0500 Lizette Koehler [EMAIL PROTECTED] wrote: :I have gone through several iterations and just cannot see the forest for the trees. :I need to sort hex data in ISPF and batch. I have tried a couple of variations but the x'A' - x'F' always go to the top of the sorted list. I really would like 0-9, x'A' - x'F' :I have not found on the ISPF sort command a hex option for sorting. And I am not sure what control cards I can use in batch sort to make it happen. :Any one willing to point me in the right direction? If not, I will write a sort process in REXX. A simple approach for ISPF is to add a non-displayed column which has the binary value and sort on it. For batch the better options have already been mentioned. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Sorting Hex Data - ISPF or Batch
I have gone through several iterations and just cannot see the forest for the trees. I need to sort hex data in ISPF and batch. I have tried a couple of variations but the x'A' - x'F' always go to the top of the sorted list. I really would like 0-9, x'A' - x'F' I have not found on the ISPF sort command a hex option for sorting. And I am not sure what control cards I can use in batch sort to make it happen. Any one willing to point me in the right direction? If not, I will write a sort process in REXX. Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Sorting Hex Data - ISPF or Batch
Lizette I use these SORT control statements to achieve what you want. * THIS CAUSES NUMBERS TO COLLATE BEFORE UPPERCASE LETTERS * GREAT FOR GETTING HEX NUMBERS IN CORRECT ORDER 0-9A-F ALTSEQ CODE=(F0B0,F1B1,F2B2,F3B3,F4B4,F5B5,F6B6,F7B7,F8B8,F9B9) SORT FIELDS=(1,4,AQ,A),SIZE=E2000 Alan -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Lizette Koehler Sent: Thursday, March 06, 2008 10:31 To: IBM-MAIN@BAMA.UA.EDU Subject: Sorting Hex Data - ISPF or Batch I have gone through several iterations and just cannot see the forest for the trees. I need to sort hex data in ISPF and batch. I have tried a couple of variations but the x'A' - x'F' always go to the top of the sorted list. I really would like 0-9, x'A' - x'F' I have not found on the ISPF sort command a hex option for sorting. And I am not sure what control cards I can use in batch sort to make it happen. Any one willing to point me in the right direction? If not, I will write a sort process in REXX. Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Sorting Hex Data - ISPF or Batch
In ISPF: If you have National Language Support, the order in which your data will be collated could depend on the status of your HEX mode. If your HEX mode status is ON, your data will be ordered according to its hexadecimal representation. If your HEX mode status is OFF, you are a National Language Support user and your installation has defined a special collating sequence table, your data will be ordered according to the sequence specified in the collating sequence table. Don Imbriale -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Lizette Koehler Sent: Thursday, March 06, 2008 11:31 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Sorting Hex Data - ISPF or Batch I have gone through several iterations and just cannot see the forest for the trees. I need to sort hex data in ISPF and batch. I have tried a couple of variations but the x'A' - x'F' always go to the top of the sorted list. I really would like 0-9, x'A' - x'F' I have not found on the ISPF sort command a hex option for sorting. And I am not sure what control cards I can use in batch sort to make it happen. Any one willing to point me in the right direction? If not, I will write a sort process in REXX. *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Sorting Hex Data - ISPF or Batch
Thanks Don and Alan, that did the trick. Lizette -Original Message- From: Field, Alan C. [EMAIL PROTECTED] Sent: Mar 6, 2008 11:34 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Sorting Hex Data - ISPF or Batch Lizette I use these SORT control statements to achieve what you want. * THIS CAUSES NUMBERS TO COLLATE BEFORE UPPERCASE LETTERS * GREAT FOR GETTING HEX NUMBERS IN CORRECT ORDER 0-9A-F ALTSEQ CODE=(F0B0,F1B1,F2B2,F3B3,F4B4,F5B5,F6B6,F7B7,F8B8,F9B9) SORT FIELDS=(1,4,AQ,A),SIZE=E2000 Alan -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Lizette Koehler Sent: Thursday, March 06, 2008 10:31 To: IBM-MAIN@BAMA.UA.EDU Subject: Sorting Hex Data - ISPF or Batch I have gone through several iterations and just cannot see the forest for the trees. I need to sort hex data in ISPF and batch. I have tried a couple of variations but the x'A' - x'F' always go to the top of the sorted list. I really would like 0-9, x'A' - x'F' I have not found on the ISPF sort command a hex option for sorting. And I am not sure what control cards I can use in batch sort to make it happen. Any one willing to point me in the right direction? If not, I will write a sort process in REXX. Lizette -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Sorting Hex Data - ISPF or Batch
On Thu, 6 Mar 2008 11:31:11 -0500 Lizette Koehler [EMAIL PROTECTED] wrote: :I have gone through several iterations and just cannot see the forest for the trees. :I need to sort hex data in ISPF and batch. I have tried a couple of variations but the x'A' - x'F' always go to the top of the sorted list. I really would like 0-9, x'A' - x'F' :I have not found on the ISPF sort command a hex option for sorting. And I am not sure what control cards I can use in batch sort to make it happen. :Any one willing to point me in the right direction? If not, I will write a sort process in REXX. A simple approach for ISPF is to add a non-displayed column which has the binary value and sort on it. For batch the better options have already been mentioned. -- Binyamin Dissen [EMAIL PROTECTED] http://www.dissensoftware.com Director, Dissen Software, Bar Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
