Can you show us a sample of input data and of data before it's sorted i.e after the INREC?
Thanks, Martin Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: martin_pac...@uk.ibm.com Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: "Sankaranarayanan, Vignesh" <vignesh.v.sankaranaraya...@marks-and-spencer.com> To: IBM-MAIN@listserv.ua.edu Date: 16/04/2014 14:56 Subject: Re: Sorting CSV data that begins with an IP address Sent by: IBM Mainframe Discussion List <IBM-MAIN@listserv.ua.edu> Yup. I used this but the file gets all messed up. I'm sure it's not the right SYSIN for what I need to do. INREC IFTHEN=(WHEN=INIT, PARSE=(%01=(ENDBEFR=C'.',FIXLEN=3), %02=(ENDBEFR=C'.',FIXLEN=3), %03=(ENDBEFR=C'.',FIXLEN=3), %04=(FIXLEN=3)), OVERLAY=(81:%01,%02,%03,%04)) SORT FORMAT=UFF,FIELDS=(81,3,A,84,3,A,87,3,A,90,3,A) OUTREC BUILD=(1,133) - Vignesh Mainframe Admin -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Scott Barry Sent: 16 April 2014 14:27 To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: Sorting CSV data that begins with an IP address Possibly the DFSORT INREC PARSE= feature might be usable to create your static-length, zone-decimal value field for the sort of a 'typical' IP address data-string in your CSV-format file. Scott Barry SBBWorks, Inc. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN MARKSANDSPENCER.COM ________________________________ Unless otherwise stated above: Marks and Spencer plc Registered Office: Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 www.marksandspencer.com Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
