Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
& yeah, above JCL is written for DFSORT forums, still must work with SyncSORT-sites as well, I've used that with little modification & it worked for me, give a try.
Hi anuj,
iam trying to compare 2 files on few keys and get non-macthing records in third file .when i execute this jcl iam getting empty output file with following errors in sysout and RC=12
SPLICE FROM(TMP1) TO(OUT) ON(1,2,CH)
SYT053E "SPLICE" STATEMENT DOES NOT CONTAIN A "WITH" OPERAND
SYT030I OPERATION COMPLETED WITH RETURN CODE 12
ON(23,16,CH)
SYT048E STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR
ON(39,15,CH)
SYT048E STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR
ON(54,6,CH)
SYT048E STATEMENT DOES NOT BEGIN WITH A VALID OPERATOR
the inputfiles are of format
0705299127390154 7575755631 00000000019100022515903811603 CM
0705300000000000 05013222216 00000000000230017023500000303 CM
0705300000000000 3052354611 00000000000080015175800006003 CM
0705300000000000 3052524370 00000000000080020190200005803 CM
0705300000000000 3052565309 00000000000450020120600060003 CM
0705300000000000 4134490030 00000000000530021461500315703 CM
and output should be
0705302196590376 3123460875 00000000000930019594200103803 CM
0705302562172386 7026834394 00000000000630019562700135303 CM
0705303026773000 5054210564 00000000002630019353000344903 CM
0705306082690777 2629494787 00000000000520020063200034703 CM
RECFM=FB,LRECL=91 FOR inputs and output files.
any suggestions
but you show only 1 file, where is the another?
What all fileds you want to join here?
What are the rules?
Intead of replying here, post it as a New Post
Hi krisprems,
i want to compare 2 files based on few keys and if non-matchig record is found it should be outputted in third file .so is it possible to do it with synctool that is ice tool.please suggest.i have posted input files and output files as new topic .please suggest.
Both the input files are of LRECL=80, Fixed-Block & there are no duplicate records in an individual file.OUT1 & OUT2 are the desired outpur for your query, OUT12 will have common records of both the files. If the above JCL does not work for you, please provide your both input files.
i have two files FILE1 and FILE2.
FILE1 contains a list of Telephone numbers(approx 600 records)
FILE2 is of length 200 bytes and contains some data along with Telephone numbers.(approx 33000 records)
Requirement:
If the TN from FILE1 matches with TN in FILE2 i want the entire record from FILE2 to be written on other file.
SUPERC shows me Inserted and Deleted lines but it does not give me the entire 200bytes of FILE2 (only 80 bytes displayed).
i want the entire record.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
I believe you will be more satisfied if you use your sort product rather than superc.
If you search in the DFSORT section you may find solutions like what you are looking for. If your system uses Syncsort, there are similar topics in the JCL section.