John McKown wrote on 04/02/2009 10:20:21 AM: > OK, my brain is just missing something. I am doing a SPLICE operation > against the RACF database unload flat file. I am trying to merge (join) > information from the type 0200 (userid), 0220 (TSO segment), and 0230 (CICS > segment) onto a single record. If I have all three records, then the output > is what I want it to be. If I have the base record (0200) and TSO record > (0220), then the output is what I want. If have have all three records, then > the output is what I want. However, if I am missing the 0220 record for a > given userid, then I am also missing the 0230 information after the SPLICE. > ... > //TOOLIN DD * > SPLICE FROM(FLATFILE) - > TO(OUTPUT1) - > ON(9,8,CH) - > USING(SPL1) - > WITHEACH - > ... > Any ideas other than I'm an idiot?
No, you're not an idiot. You're just using the wrong parameter. To do what you want requires the WITHANY parameter rather than the) WITHEACH parameter. WITHANY was introduced with z/OS DFSORT V1R5 PTF UK90013 in July, 2008. For complete details, see: http://www.ibm.com/systems/support/storage/software/sort/mvs/ugpf/ Frank Yaeger - DFSORT Development Team (IBM) - [email protected] Specialties: FINDREP, WHEN=GROUP, DATASORT, ICETOOL, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
