can we reformat a superc output file by syncsort

Anuj Dhawan · Posted: Wed Jun 27, 2007 9:57 pm

saujanya,

On first page you have shown the SUPERC output; for SORT solution, please provide the input/s & the desired output.

I hope you would like to have two outputs:
(A-B)= Records only in A not in B
(B-A)= Records only in B not in A

where A & B are two input files.

If yes, see the "Create files with matching and non-matching records" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

You need to do some modification in the above JCL, if you face some problem, please let us know.

Anuj Dhawan · Posted: Wed Jun 27, 2007 10:02 pm

& 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.

student_mf · New User Joined: 15 Jun 2007 Posts: 23 Location: pune

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

//SYNCSORT EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//SSMSG DD SYSOUT=*
//IN1 DD DSN=MT.testfile.T1,DISP=SHR
//IN2 DD DSN=MT.testfile.T2,DISP=SHR
//TMP1 DD DSN=&&TEMP1,DISP=(MOD,PASS),
// DCB=(RECFM=FB,LRECL=90,BLKSIZE=27000),
// SPACE=(27000,(15000,100),RLSE),UNIT=DISK
//OUT DD DSN=outfile.test.TSP,DISP=(,CATLG),
// DCB=(RECFM=FB,LRECL=90,BLKSIZE=27000),
// SPACE=(27000,(15000,100),RLSE),UNIT=DISK
//TOOLIN DD *
COPY FROM(IN1) TO(TMP1) USING(CPY1)
COPY FROM(IN2) TO(TMP1) USING(CPY2)
SPLICE FROM(TMP1) TO(OUT) ON(1,2,CH)
ON(3,4,CH)
ON(7,16,CH)
ON(23,16,CH)
ON(39,15,CH)
ON(54,6,CH)
ON(60,7,CH)
ON(81,1,CH)
//CPY1CNTL DD *
OUTREC FIELDS=(1:1,90)
/*
//CPY2CNTL DD *
OUTREC FIELDS=(1:1,90)
/*
//

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

student_mf · New User Joined: 15 Jun 2007 Posts: 23 Location: pune

Hi anuj i have modified the //TOOLIN DD * as below but still not working
and iam getting following TOOLMSG

SYT053E "SPLICE" STATEMENT DOES NOT CONTAIN A "WITH" OPERAND
SYT030I OPERATION COMPLETED WITH RETURN CODE 12

SYT015I PROCESSING MODE CHANGED FROM "STOP" TO "SCAN" DUE TO OPERATION FAILURE

SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 12 and output file is an empty file.

//TOOLIN DD *
COPY FROM(IN1) TO(TMP1) USING(CPY1)
COPY FROM(IN2) TO(TMP1) USING(CPY2)
SPLICE FROM(TMP1) TO(OUT) ON(1,2,CH) -
ON(3,4,CH) -
ON(7,16,CH) -
ON(23,16,CH) -
ON(39,15,CH) -
ON(54,6,CH) -
ON(60,7,CH) -
ON(81,1,CH)[/quote]

and even i have tried with the following
//TOOLIN DD *
COPY FROM(IN1) TO(TMP1) USING(CPY1)
COPY FROM(IN2) TO(TMP1) USING(CPY2)
SPLICE FROM(TMP1) TO(OUT) WITH(1,2) -
WITH(3,4) -
WITH(7,16) -
WITH(23,16) -
WITH(39,15) -
WITH(54,6) -
WITH(60,7) -
WITH(81,1)
//CPY1CNTL DD *
OUTREC FIELDS=(1:1,90)
/*
//CPY2CNTL DD *
OUTREC FIELDS=(1:1,90)
and iam getting empty output file and following TOOLMSG

SYT053E "SPLICE" STATEMENT DOES NOT CONTAIN AN "ON" OPERAND
SYT030I OPERATION COMPLETED WITH RETURN CODE 12

SYT015I PROCESSING MODE CHANGED FROM "STOP" TO "SCAN" DUE TO OPERATION FAILURE

SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 12

so please suggest

krisprems · Posted: Thu Jun 28, 2007 11:59 am

student_mf

The error thrown, clearly states that the keyword WITH is missing in the SPLICE statement.

student_mf · New User Joined: 15 Jun 2007 Posts: 23 Location: pune

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.

Anuj Dhawan · Posted: Mon Jul 02, 2007 8:14 pm

student_mf,

Sorry for a delayed reply, was away from net since some days.

In your JCL you are using multiple WITH & ON, do you want to compare files on differnet keys ?
However, you can try following JCL:

krisprems · Posted: Thu Jul 05, 2007 12:16 pm

anuj_model
student_mf's question was considered under OFF TOPICS @
http://ibmmainframes.com/viewtopic.php?t=22316

Anuj Dhawan · Posted: Thu Jul 05, 2007 2:38 pm

Hi,

Thanks for redirecting.
By the way, you can call me Anuj.

loga_nathan_m · New User Joined: 07 Jun 2007 Posts: 40 Location: India

hi all,

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.

Kindly reply if u have answers...

thanks in advance.

dick scherrer · Posted: Tue Mar 25, 2008 6:47 am

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.

Alissa Margulies · Posted: Wed Mar 26, 2008 12:05 am