View previous topic :: View next topic
|
Author |
Message |
rohit510
New User
Joined: 08 Jan 2008 Posts: 18 Location: delhi
|
|
|
|
I need a SYNCSORT job which compares first 34 characters from two input files and creates a ouput file which contains no matches in file 1.
LRECL OF FRST FILE:195
LRECL OF SECOND FILE:195
LRECL OF OUTPUT FILE:195 |
|
Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006 Posts: 649 Location: India
|
|
|
|
Code: |
//*********************************
//SORT1 EXEC PGM=SYNCSORT
//SORTJNF1 DD DSN=FILE-1
//SORTJNF2 DD DSN=FILE-2
//SYSOUT DD SYSOUT=*
//SORTOUT DD DSN=O/P FILE
//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(1,34,A)
JOINKEYS FILE=F2,FIELDS=(1,34,A)
JOIN UNPAIRED,F1,ONLY
REFORMAT FIELDS=(F1:1,195)
SORT FIELDS=COPY
//*
|
|
|
Back to top |
|
|
rohit510
New User
Joined: 08 Jan 2008 Posts: 18 Location: delhi
|
|
|
|
Thanks for the reply kRISPREMs
but its not working for me.Its abending with U00016.
Warning being generated is SORTOUT not defined.
can you please help me in solving this kRISPREMs |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
Quote: |
but its not working for me |
Which version of Syncsort you are running? |
|
Back to top |
|
|
rohit510
New User
Joined: 08 Jan 2008 Posts: 18 Location: delhi
|
|
|
|
Its working fine now.
what can i do to fill the first two fields in output file with spaces alone. |
|
Back to top |
|
|
krisprems
Active Member
Joined: 27 Nov 2006 Posts: 649 Location: India
|
|
|
|
replace the REFORMAT statement like this
Code: |
REFORMAT FIELDS=(C' ',F1:3,195) |
Its an untested suggestion. Please let us know if you have any problem in using this |
|
Back to top |
|
|
|