Thanks. this sounds like it might be doable. I think we can find a column in both files that already contain a space to the first 'expansion' step would not be necessary.
-----Original Message----- From: IBM Mainframe Discussion List on behalf of Ken Leidner Sent: Mon 7/9/2012 6:45 AM To: [email protected] Subject: 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 [email protected] ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] 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 [email protected] with the message: INFO IBM-MAIN
