Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 
to compare 2 file and get the matched & non matched reco

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Thu May 27, 2010 9:53 pm    Post subject: to compare 2 file and get the matched & non matched reco
Reply with quote

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
View user's profile Send private message

CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu May 27, 2010 9:57 pm    Post subject:
Reply with quote

Please post your JCL and all sysouts.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 27, 2010 9:58 pm    Post subject:
Reply with quote

Hello,

Post your jcl and control statements as well as the complete diagnostic informaton genereated by the run.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu May 27, 2010 10:06 pm    Post subject:
Reply with quote

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
View user's profile Send private message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Thu May 27, 2010 10:10 pm    Post subject: Reply to: to compare 2 file and get the matched & non ma
Reply with quote

Hi,

Pls find the attachment

Thanks,
Venkat

attachment deleted because of a useless waste of resources
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu May 27, 2010 10:21 pm    Post subject:
Reply with quote

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
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Thu May 27, 2010 10:22 pm    Post subject:
Reply with quote

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
View user's profile Send private message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Thu May 27, 2010 10:27 pm    Post subject: Reply to: to compare 2 file and get the matched & non ma
Reply with quote

is there any material for this reformat and join..
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu May 27, 2010 10:47 pm    Post subject: Re: Reply to: to compare 2 file and get the matched & no
Reply with quote

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
View user's profile Send private message
venkatatcts

New User


Joined: 16 Mar 2009
Posts: 55
Location: India

PostPosted: Fri May 28, 2010 2:12 pm    Post subject: Reply to: to compare 2 file and get the matched & non ma
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Fri May 28, 2010 7:52 pm    Post subject: Re: Reply to: to compare 2 file and get the matched & no
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us