WER202A SORTOUT RECFM INCOMPATIBLE



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

WER202A SORTOUT RECFM INCOMPATIBLE

Postby mberger » Thu May 06, 2010 9:07 pm

I am receiving the same issue when I attempt to JOIN 2 VB files.
File 1 is VB, LRECL=3588, the key is in byte 167 for a length of 6 (added +4 for VB)
File 2 is VB, LRECL=84, the key is in byte 1 for a length of 6 (added +4 for VB)
I want to output all file 1 records where the key exists on File 2.

Here is my SORT control card:
    JOINKEYS FILES=F1,FIELDS=(171,6,A)
    JOINKEYS FILES=F2,FIELDS=(5,6,A) 
    REFORMAT FIELDS=(F1:1,3588)                        (I originally tried this with F1:5,3588 and received the same error below)
    SORT FIELDS=(171,6,CH,A)         

Error messages after submitting job:
WER481I  JOINKEYS REFORMAT RECORD LENGTH= 3588, TYPE = F   (original try: JOINKEYS REFORMAT RECORD LENGTH= 3584, TYPE = F)
WER202A  SORTOUT  RECFM INCOMPATIBLE                             
WER110I  SORTOUT  : RECFM=VB   ; LRECL=      ; BLKSIZE=           
WER482I  JNF1 STATISTICS                                         
WER483B  1,984K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER483B     0 BYTES RESERVE REQUESTED, 436K BYTES USED           
WER108I  SORTJNF1 : RECFM=VB   ; LRECL=  3588; BLKSIZE= 27998     
WER482I  JNF2 STATISTICS                                         
WER483B  5,972K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER483B     0 BYTES RESERVE REQUESTED, 436K BYTES USED           
WER108I  SORTJNF2 : RECFM=VB   ; LRECL=    84; BLKSIZE= 27998     

The error is stating that the LRECL is 3588 and the record format is F(ixed). I defined the output file as RECFM VB, LRECL 3588.

My original intention was to join a FB80 and VB3588 file into a VB3588 output file but was getting incompatible errors so I copied the FB80 file to a VB84 file so I would at least get past that problem.

Thanks.
mberger
 
Posts: 9
Joined: Thu May 06, 2010 8:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby CICS Guy » Thu May 06, 2010 9:50 pm

Please post all the JCL.
CICS Guy
 
Posts: 246
Joined: Wed Jun 20, 2007 4:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby William Thompson » Thu May 06, 2010 10:00 pm

About the error WER202A ddname RECFM INCOMPATIBLE, SyncSort for z/OS 1.3 Programmer’s Guide wrote:EXPLANATION: The ddname will be SORTOUT, SORTOFxx,
SORTOFx or the ddname provided by an OUTFIL FNAMES parameter.
The record format of the output file is not the same as the input file, the
record format of a record provided by an E15, or the record format created
by a JOIN REFORMAT statement. (Both formats must be either
fixed-length or variable-length.) If you want to convert a variablelength
input file into a fixed-length output file, use the CONVERT
parameter of the OUTFIL or OUTREC control statements. If you want
to convert a fixed-length input file into a variable-length output file, use
the FTOV parameter of the OUTFIL control statement.

About Specifying the FIELDS Parameter for Variable-Length Records, SyncSort for z/OS 1.3 Programmer’s Guide wrote:If the REFORMAT statement only defines p,l fields, then the output of the join will be a
fixed-length record. If a variable-length record format is desired when one or both input
files are variable-length, then the first p,l REFORMAT field must be 1,4 (from either
SORTJNFn input file) to define the RDW. This p,l specification of 1,4 must reference an Fn
that is a variable-length file. The variable portion of the record must then be specified as
the last REFORMAT field by coding a position p without a length l. If both files are
variable-length, then the variable portion from each of the variable-length input files may
be specified once at the end of the REFORMAT statement.
William Thompson
 
Posts: 81
Joined: Sat Jun 09, 2007 4:24 am
Location: Tucson AZ
Has thanked: 0 time
Been thanked: 1 time

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby Alissa Margulies » Thu May 06, 2010 10:01 pm

MBERGER,

Change your REFORMAT statement to the following:
REFORMAT FIELDS=(F1:1,4,5)


And since you are sorting on the JOINKEYS, you can simply code SORT FIELDS=COPY.

Let us know if you still encounter a problem after making this change.

Regards,
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby mberger » Thu May 06, 2010 10:41 pm

Thanks William and Alissa,

Good information on the error messages and the modification to the REFORMAT statement worked perfectly.

I was originally attempting to join a VB and an FB file by key matching, please verify that I indeed have to convert the FB to a VB file (or convert the VB files to an FB file) before joining the two files to generate a VB output file. Would there be any way to join the FB and VB input files to generate a VB output file without having to first transform one of the input files?

Thanks again.
mberger
 
Posts: 9
Joined: Thu May 06, 2010 8:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby Alissa Margulies » Thu May 06, 2010 11:06 pm

The files to be joined do NOT need to have the same RECFM. You do not need to convert either file.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby mberger » Thu May 06, 2010 11:53 pm

Thanks again, that worked perfectly.
mberger
 
Posts: 9
Joined: Thu May 06, 2010 8:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: WER202A SORTOUT RECFM INCOMPATIBLE

Postby RajeshT » Wed Feb 23, 2011 6:47 pm

Thank you from my end too. It just worked for me on the same issue while joining an FB with VB.

Thank You.
Rajesh.
RajeshT
 
Posts: 22
Joined: Tue May 04, 2010 10:19 pm
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post