I have one Transaction file and one Master file. Master file contains the mapping of Print id and Report Id. However Transaction File has only Print Id. I want to get a output transaction file which will have both Print Id and Report Id for all the records. In other words for each transaction record I want to pull the report id field from Master file. Here are the sample data from two files and expected output. I tried to do it with ICETOOL and SPLICE operator. But not getting the required results. Any suggestion is appreciated!
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
manopatil,
Assuming that both master and trans file are of same length,you can do this kind of thing more easily and efficiently with the new WHEN=GROUP function of DFSORT available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008) like this
I tried the ICETOOL as per your suggestion but JCL shows me the syntax error in "OUTREC" or "INREC" field. I dont understand what is wrong. Please suggest
IEF375I JOB/DSTSPLT /START 2008270.1627
IEF376I JOB/DSTSPLT /STOP 2008270.1627 CPU 0MIN 00.02SEC SRB 0MIN 00.00S
SYNCSORT FOR Z/OS 1.2.2.3R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSO
z/OS 1.8.0
PRODUCT LICENSED FOR CPU SERIAL NUMBER 1C2AD, MODEL 2096 U03 LICEN
SYSIN :
OPTION COPY
INREC IFTHEN=(WHEN=GROUP,
*
BEGIN=(9,4,CH,EQ,C'RPT='),PUSH=(41:13,8))
OUTFIL INCLUDE=(41,8,CH,GT,C' ',AND,9,4,CH,NE,C'RPT='),
BUILD=(1,8,41,8,13,5)
WER268A INREC STATEMENT : SYNTAX ERROR
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE