Re: SYNCSORT - Save a data item for use in OUTREC output
Another source for assistance would be joining Syncsort's user community. This community is a blog site where you can get product usage assistance from a wider community. The site to register and log on is http://community.syncsort.com/ This community consists of public and private groups of Syncsort product users from many companies and many countries. Syncsort employees participate in and host many of this community's groups. This would seem to be an ideal place to post your HOWTO type of question and get some quick targeted help. Best Regards, Sam Knutson -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Sunday, July 08, 2012 3:23 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Wayne It appears the E15 exit will not work for our needs. And I humbly apologize as the example I gave was far too simplistic and I left off some of the requirements that make the E15 exit 'probably' not doable. - First of all the E15 requires the creation of another program which is one thing we do not care to do. - Secondly, the data item we would like to save and utilize actually will only be used within the HEADER record for any OUTFILs that do not have records in the input file. That is, if an OUTFIL has zero records written then the HEADER and TRAILER written for it will have a count of 0. But... we would like the saved data (a date range) to be plugged into the Header title area. This date is part of the input record and works fine for OUTFIL groups with an input record but when the HEADER is written for the OUTFIL groups when there are zero input records for the group, this data is not available. Thanks Bill -Original Message- From: IBM Mainframe Discussion List on behalf of George, William@FTB Sent: Sat 7/7/2012 3:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Thanks, I'll look into this! -Original Message- From: IBM Mainframe Discussion List on behalf of Wayne Bickerdike Sent: Sat 7/7/2012 1:38 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Use an E15 exit to read the input file, store the value you need to preserve and on each successive record just overwrite with the saved value and pass the record to sort. I have a few examples of E15 exit code but the SYNCSORT manual should have some examples of exit code. Wayne Bickerdike On Sat, Jul 7, 2012 at 7:40 AM, George, William@FTB william.geo...@ftb.ca.gov wrote: Sorry, the formatting didn't retain how I had originally keyed it. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Friday, July 06, 2012 2:36 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT - Save a data item for use in OUTREC output Is there a means via SYNCSORT to save a data item found on the 1st input record and then have it placed on all subsequent output records. For example. 1. Input 1 - 07/06/2012 asfasdlfjl. (save the date 07/06/2012 and not output the record) 2. Input 2 - poiutkjgfertqe Output - 07/06/2012 poiutkjgfertqe... That is, place the saved data item (date) someplace in the output record 3. Input 3 - (same as #2 and to the end of file) Thanks for any insights. ith the message: INFO IBM-MAIN This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT - Save a data item for use in OUTREC output
As a concept, I would copy the first record to a new dataset (using sort) and expand the record by one character - a blank. In a second OUTFIL statement I would expand all of the other records by the same 1 character - a blank. Then I would JOIN the two expanded datasets using the added blank as the key. I would tell the JOIN that the records are already sorted. Then in the JOIN's REFORMAT statement you can add the field from the one record file to where ever you want in all of the records. You can decide if the first record record should be in both expanded files or not (I would think so). Ken Leidner kleid...@earthlink.net -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT - Save a data item for use in OUTREC output
Thanks Sam. I did just this over the weekend! -Original Message- From: IBM Mainframe Discussion List on behalf of Knutson, Sam Sent: Mon 7/9/2012 5:13 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Another source for assistance would be joining Syncsort's user community. This community is a blog site where you can get product usage assistance from a wider community. The site to register and log on is http://community.syncsort.com/ This community consists of public and private groups of Syncsort product users from many companies and many countries. Syncsort employees participate in and host many of this community's groups. This would seem to be an ideal place to post your HOWTO type of question and get some quick targeted help. Best Regards, Sam Knutson -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Sunday, July 08, 2012 3:23 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Wayne It appears the E15 exit will not work for our needs. And I humbly apologize as the example I gave was far too simplistic and I left off some of the requirements that make the E15 exit 'probably' not doable. - First of all the E15 requires the creation of another program which is one thing we do not care to do. - Secondly, the data item we would like to save and utilize actually will only be used within the HEADER record for any OUTFILs that do not have records in the input file. That is, if an OUTFIL has zero records written then the HEADER and TRAILER written for it will have a count of 0. But... we would like the saved data (a date range) to be plugged into the Header title area. This date is part of the input record and works fine for OUTFIL groups with an input record but when the HEADER is written for the OUTFIL groups when there are zero input records for the group, this data is not available. Thanks Bill -Original Message- From: IBM Mainframe Discussion List on behalf of George, William@FTB Sent: Sat 7/7/2012 3:15 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Thanks, I'll look into this! -Original Message- From: IBM Mainframe Discussion List on behalf of Wayne Bickerdike Sent: Sat 7/7/2012 1:38 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: SYNCSORT - Save a data item for use in OUTREC output Use an E15 exit to read the input file, store the value you need to preserve and on each successive record just overwrite with the saved value and pass the record to sort. I have a few examples of E15 exit code but the SYNCSORT manual should have some examples of exit code. Wayne Bickerdike On Sat, Jul 7, 2012 at 7:40 AM, George, William@FTB william.geo...@ftb.ca.gov wrote: Sorry, the formatting didn't retain how I had originally keyed it. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Friday, July 06, 2012 2:36 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT - Save a data item for use in OUTREC output Is there a means via SYNCSORT to save a data item found on the 1st input record and then have it placed on all subsequent output records. For example. 1. Input 1 - 07/06/2012 asfasdlfjl. (save the date 07/06/2012 and not output the record) 2. Input 2 - poiutkjgfertqe Output - 07/06/2012 poiutkjgfertqe... That is, place the saved data item (date) someplace in the output record 3. Input 3 - (same as #2 and to the end of file) Thanks for any insights. ith the message: INFO IBM-MAIN This email/fax message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution of this email/fax is prohibited. If you are not the intended recipient, please destroy all paper and electronic copies of the original message. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN __ 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...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT - Save a data item for use in OUTREC output
Use an E15 exit to read the input file, store the value you need to preserve and on each successive record just overwrite with the saved value and pass the record to sort. I have a few examples of E15 exit code but the SYNCSORT manual should have some examples of exit code. Wayne Bickerdike On Sat, Jul 7, 2012 at 7:40 AM, George, William@FTB william.geo...@ftb.ca.gov wrote: Sorry, the formatting didn't retain how I had originally keyed it. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Friday, July 06, 2012 2:36 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT - Save a data item for use in OUTREC output Is there a means via SYNCSORT to save a data item found on the 1st input record and then have it placed on all subsequent output records. For example. 1. Input 1 - 07/06/2012 asfasdlfjl. (save the date 07/06/2012 and not output the record) 2. Input 2 - poiutkjgfertqe Output - 07/06/2012 poiutkjgfertqe... That is, place the saved data item (date) someplace in the output record 3. Input 3 - (same as #2 and to the end of file) Thanks for any insights. __ 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...@listserv.ua.edu with the message: INFO IBM-MAIN -- Wayne V. Bickerdike -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: SYNCSORT - Save a data item for use in OUTREC output
Sorry, the formatting didn't retain how I had originally keyed it. -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Friday, July 06, 2012 2:36 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: SYNCSORT - Save a data item for use in OUTREC output Is there a means via SYNCSORT to save a data item found on the 1st input record and then have it placed on all subsequent output records. For example. 1. Input 1 - 07/06/2012 asfasdlfjl. (save the date 07/06/2012 and not output the record) 2. Input 2 - poiutkjgfertqe Output - 07/06/2012 poiutkjgfertqe... That is, place the saved data item (date) someplace in the output record 3. Input 3 - (same as #2 and to the end of file) Thanks for any insights. __ 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...@listserv.ua.edu with the message: INFO IBM-MAIN