thanks for the link but we are using only Syncsort i guess because till now i havent seen dfsort in any proc.so can you please send me a link for Syncsort.
my record length is 90 and i dont know whether my shop has dfsort or icetool how to find it out .actually iam comparing two files and getting duplicates in third file by using superc .previously we used comparex for the same.The ouptput of superc has listing someting like below 2 recs
D - 0705302196590376 3123460875 00000000000930019594200103803 CMD DA 8 DEL= 1 49746 49746
D - 0705302562172386 7026834394 00000000000630019562700135303 CMD DA 8 DEL= 1 58961 58962
and i need to get rid of all those listing of superc and get only records in output somehow like below
0705302196590376 3123460875 00000000000930019594200103803 CMD DA
0705302562172386 7026834394 00000000000630019562700135303 CMD DA
.you have given the code for ICETOOL?.so any sort of suggestion on this would be fine.
as mention above we can only get the records which has 'D' in field 2 and similarly can write a step to get 'I' records... my concern is that i would need the matching records in file A and B.. the output is shown below..
i need common record, unmatching records in file 1 and unmatching records in file 2 in different file.. hence SUPERC is best suited.
by the above method (using INCLUDE COND) i was able to get unmatching record in different file.. but the matching record or common record, i was not able to strip exactly...
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
loga_nathan_m wrote:
i need common record, unmatching records in file 1 and unmatching records in file 2 in different file..
Hi,
It means, you have two input files, say File-A & File-B & you need two different files (A-B) & (B-A) in output, where
(A-B)= Records only in A not in B
(B-A)= Records only in B not in A
Right?
SORT FIELDS=COPY
INCLUDE COND=(1,3,CH,EQ,C'I -',OR,1,3,CH,EQ,C'D -')
INREC FIELDS=(1:5,90)
Yes your sort card does work but remember that it is not separating all the 'D -' and 'I -' records....
The record is either 'I -' or 'D -' its written into a single o/p file.
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
dick scherrer wrote:
Hello,
As this is a Syncsort question, i suspect this
Quote:
Can you use ICETOOL?
may not work. It is worth a try, but don't be surprised if it will not do what you want.
It does work with SyncSort as well. We need to replace DD name DFSMSG of ICETOOL with SSMSG , SYNCTOOL will be invoked in back-end. For reference purpose following JCL can be used as an example:
JCL:
SYT000I SYNCTOOL RELEASE 1.5.1 - COPYRIGHT 2004 SYNCSORT
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED
COPY FROM(IN1) TO(TMP1) USING(CPY1)
SYT020I SYNCSORT CALLED WITH IDENTIFIER "0001"
SYT030I OPERATION COMPLETED WITH RETURN CODE 0
COPY FROM(IN2) TO(TMP1) USING(CPY2)
SYT020I SYNCSORT CALLED WITH IDENTIFIER "0002"
SYT030I OPERATION COMPLETED WITH RETURN CODE 0
SPLICE FROM(TMP1) TO(OUT) ON(1,3,CH) WITH(11,5)
SYT020I SYNCSORT CALLED WITH IDENTIFIER "0003"
SYT031I NUMBER OF RECORDS PROCESSED: 000000000000009
SYT026I NUMBER OF SELECTED RECORDS: 000000000000003
SYT030I OPERATION COMPLETED WITH RETURN CODE 0
SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 0
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
Hello,
Yes it will run - it will not always work.
When you are a Syncsort installation and EXEC PGM=ICETOOL, it is dynamically replaced with Synctool (it is an alias) that does not have all of the features that ICETOOL has.
As i said earlier, worth a try, but not to be surprised if you do something that is a working ICETOOL example that abends or runs wrong on the Syncsort system.
SYNCTOOL is not covered by standard, distributed documentation yet - it was provided to ease transition from DFSORT for sites that chose to switch to Syncsort. It was implemented to use the same syntax as ICETOOL, but ICETOOL has had enhancements since the original SYNCTOOL was released. It is my understanding that a new release and documentation for SYNCTOOL is planned for early next year (2008).
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
dick scherrer wrote:
When you are a Syncsort installation and EXEC PGM=ICETOOL, it is dynamically replaced with Synctool (it is an alias) that does not have all of the features that ICETOOL has.
Yeah Dick,
I don't have an official-documentation on SYNCTOOL & I can know about different feactures of it.. only by experiment. As SPLICE work on SyncSort Sites while PARSE doesn't.
JCL provided by me will work for OPs' requirement(with some modifications), yeah it's not necessaary that all the other feactures of ICETOOL must be available in SYNCTOOL as well, it can only be said after official document release. Frank takes AD here.
Hi anuj,
actually i have used superc in one step and syncsort in other step to get the desired output as shown in first page that is comparing two recs and getting non matching recs .but if i can do it in single step using syncsort that would be good. is it possible to do with synctool.as you suggested .
Joined: 22 Apr 2006 Posts: 6248 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
