Hi,
I have an Omegamon report that lists average response time for a transaction, the count and the name but the Period is only list for the first transaction even though it applies to the following transactions. I have a field in this case that is a Date/Time and I want to repeat that field for the following records while it is blank. The below is an example of the output before sorting ----START----- -----STOP----- NAME COUNT RESP 01/20/12 08:00 01/20/12 08:59 XRQ0 1 1.419 X257 63 .178 01/20/12 09:00 01/20/12 09:59 ACFT 12 .001 CATA 177 .008 CATD 34 .005 CDTS 9 .003 CESN 204 .010 CITS 161 .017 CQRY 177 .013 After sorting the Start and Stop date/time has been repeated for the following records while that field is blank. ----START----- -----STOP----- NAME COUNT RESP 01/20/12 08:00 01/20/12 08:59 XRQ0 1 1.419 01/20/12 08:00 01/20/12 08:59 X257 63 .178 01/20/12 09:00 01/20/12 09:59 ACFT 12 .001 01/20/12 09:00 01/20/12 09:59 CATA 177 .008 01/20/12 09:00 01/20/12 09:59 CATD 34 .005 01/20/12 09:00 01/20/12 09:59 CDTS 9 .003 01/20/12 09:00 01/20/12 09:59 CESN 204 .010 01/20/12 09:00 01/20/12 09:59 CITS 161 .017 01/20/12 09:00 01/20/12 09:59 CQRY 177 .013 Thanks James -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Elardus Engelbrecht Sent: 30 January 2012 12:55 To: IBM-MAIN@bama.ua.edu Subject: Re: Sort repeating date field Chambers, James wrote: >I am trying to repeat the Start and end Date/Time for an Omegamon Cics report. Is it possible using DFSORT repeat a field for all the records after that have a blank for that field? >The below is an example of the output I'm not really sure what you want, could you be kind to post the example you received and what you actually want. With both outputs (received and expected) available for comparision, someone can probably see exactly what you want. Thanks in advance. Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN -- This is a confidential communication and is intended only for the addressee indicated in the message (or duly authorised to be responsible for the delivery of the message to such person). You are specifically prohibited from copying this message or delivering the same, or any part thereof, to any other person, whomsoever or howsoever, unless you receive written authorisation from us to do. If you are anyone other than the intended addressee, or person duly authorised and responsible for the delivery of this message to the intended addressee, you should destroy this message and notify us immediately. Please note that we accept no responsibility whatsoever in the event that this message or any other email message or any part thereof becomes known or is communicated to anyone other than the intended recipient or other person authorised in writing by us to receive it, howsoever arising and disclaim all liability for any losses or damage which may be sustained by any person as a result thereof. Irish Life Assurance plc is regulated by the Central Bank of Ireland. Irish Life Financial Services Limited is regulated by the Central Bank of Ireland. "Irish Life" is a member of the Irish Life and Permanent plc group. Irish Life Assurance plc is a company registered in Ireland. Registered office is situated at Irish Life Centre, Lower Abbey Street, Dublin 1. Registered Number 152576. Irish Life Financial Services Limited is a company registered in Ireland. Registered office is situated at Irish Life Centre, Lower Abbey Street, Dublin 1. Registered Number 489221. ============================================================================== ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: INFO IBM-MAIN