See, I told you it was an interesting problem. :-) Cheers, Martin
Martin Packer, zChampion, Principal Systems Investigator, Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: [email protected] Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: "Chase, John" <[email protected]> To: [email protected] Date: 10/12/2014 13:16 Subject: Re: I want to add data of 30 VSAM files to one PS flat file. Sent by: IBM Mainframe Discussion List <[email protected]> > -----Original Message----- > From: IBM Mainframe Discussion List On Behalf Of MURALI KANNAN > Sent: Wednesday, December 10, 2014 4:13 AM > > I would sort the VSAM files using a key and then copy the data to flat file, to avoid duplication or > merging of data. > Correct me if I am wrong. The OP did not specify what type of VSAM datasets are involved. If KSDS, they are already sorted on a key value, and might be amenable to a MERGE operation (but what about duplicate keys?). Other considerations: 1) Are all the VSAM datasets the same type? 2) Do they all have the same RECFM and LRECL? 3) are there any alternate indices in the set? Based on the limited information given originally, the simplest means seems to be IDCAMS REPRO from each VSAM dataset in turn, to a VB "flat file" coded with DISP=MOD. Whether that output VB "flat file" might be useful is a separate problem. -jc- ********************************************************************** Information contained in this e-mail message and in any attachments thereto is confidential. If you are not the intended recipient, please destroy this message, delete any copies held on your systems, notify the sender immediately, and refrain from using or disclosing all or any part of its content to any other person. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] 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 [email protected] with the message: INFO IBM-MAIN
