View previous topic :: View next topic
|
Author |
Message |
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
Earlier i have done comparison (to compare 2 file and get the matched & non matched records) using the sort. But when do this in syncsort i am getting a syntax error - WRE028A.
How to do this in SYNCSORT.
Thanks
Venkat. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Please post your JCL and all sysouts. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Post your jcl and control statements as well as the complete diagnostic informaton genereated by the run. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Venkat,
There is no WER028A SyncSort message. A WER268A posts when there is a control statement syntax error. Please provide us with the information that was previously requested by Bill (CICS Guy) and Dick so that we can better assist you. Please also be sure to include your SyncSort release.
Thank you, |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
Pls find the attachment
Thanks,
Venkat
attachment deleted because of a useless waste of resources |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Based on your REFORMAT statement, you only have 14 bytes coming out of the JOIN processing.
You can't OUTREC 933 bytes when you only have 14.
Furthermore, you need to remove the comma after the SORT statement. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
I believe that the OUTFIL statement is not an option of the SORT statement, try getting rid of the comma......
What do you have against a simple cut&paste? |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
is there any material for this reformat and join.. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
venkatatcts wrote: |
is there any material for this reformat and join.. |
To request manuals, please contact me offline at alissa.margulies@syncsort.com.
Thank you, |
|
Back to top |
|
|
venkatatcts
New User
Joined: 16 Mar 2009 Posts: 55 Location: India
|
|
|
|
Hi,
Now i am getting the following error:
SYSIN :
JOINKEYS FILES=F1,FIELDS=(1,7,A)
JOINKEYS FILES=F2,FIELDS=(1,7,A)
REFORMAT FIELDS=(F1:1,933,F2:1,10)
SORT FIELDS=COPY
OUTFIL FNAMES=OUT,OUTREC=(1:933)
WER164B 5,704K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,000K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER481I JOINKEYS REFORMAT RECORD LENGTH= 943, TYPE = F
WER231A OUT OUTREC - ILLEGAL DATA FIELD
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER482I JNF1 STATISTICS
WER483B 2,836K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER483B 0 BYTES RESERVE REQUESTED, 1,000K BYTES USED
WER108I SORTJNF1 : RECFM=FB ; LRECL= 933; BLKSIZE= 27990
WER482I JNF2 STATISTICS
WER483B 2,548K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER483B 0 BYTES RESERVE REQUESTED, 1,000K BYTES USED
WER108I SORTJNF2 : RECFM=FB ; LRECL= 10; BLKSIZE= 27990 |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
venkatatcts wrote: |
OUTFIL FNAMES=OUT,OUTREC=(1:933)
WER231A OUT OUTREC - ILLEGAL DATA FIELD |
First of all, the correct syntax would be
Code: |
OUTFIL FNAMES=OUT,OUTREC=(1,933) |
where there is a comma instead fo a colon.
However, if you just want to write out 933 bytes from F1, then why not just specify the following:
Code: |
JOINKEYS FILES=F1,FIELDS=(1,7,A)
JOINKEYS FILES=F2,FIELDS=(1,7,A)
REFORMAT FIELDS=(F1:1,933)
SORT FIELDS=COPY |
|
|
Back to top |
|
|
|