Thanks Chris! Much appreciated. Bill
-----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Blaicher, Christopher Y. Sent: Wednesday, November 16, 2011 6:44 AM To: IBM-MAIN@bama.ua.edu Subject: Re: SYNCSORT - No records message Bill, I monitor the IBM-MAIN list for Syncsort and saw your request. I am currently researching your request and have asked some of my associates about it to see if we can solve it. Right off the bat we all thought of a simple TRAILER1 that would say "n NUMBER OF RECORDS OUTPUT" or the like, where n would be the number of records, but that does not meet your no additional records if data is in the file requirement. I will get back to you in the next day or two with our best solution to your requirements. Chris Blaicher Senior Software Engineer, Software Services Syncsort Incorporated 50 Tice Boulevard, Woodcliff Lake, NJ 07677 P: 201-930-8260 | M: 512-627-3803 E: cblaic...@syncsort.com www.syncsort.com Check out our Knowledge Base at www.syncsort.com/support Syncsort aims for the best product and service experience. We welcome your feedback. -----Original Message----- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of George, William@FTB Sent: Tuesday, November 15, 2011 3:35 PM To: MVS List Server 1 Subject: SYNCSORT - No records message I have a SYNCSORT job that splits a large input file into many other specific files. If any of the files ends up with no records written to it is it possible, within the SORT statements, to write out a single record with a message? For example "NO RECORDS FOR THIS FILE" when this condition is found? If the TRAILER statement is used to do this in some manner I would not want a trailer record written to the files with data however. Thanks for any insights. Bill ______________________________________________________________________ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu 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 lists...@bama.ua.edu 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 lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html