MVSFORUMS.com

vak255:

Please try this:

//STEP EXEC PGM=SORT
//SORTOUT DD SYSOUT=*
//SORTJNF1 DD your.input.fileA
//SORTJNF2 DD your.input.fileB
//SORTOUT DD SYSOUT=*
//SYSIN DD *
JOINKEYS FILE=F ...

Yak255:

The WER230A SORTOUT OUTREC FIELD OUTSIDE RANGE is issued because your REFORMAT statement is building a 84-byte record (80 bytes from F1 plus 4 bytes from F2), but your BUILD statement refer ...

nithyakothai:

Using your simple example I was able to produce the desired results using these control statements (requires SyncSort for z/OS 1.3.2):

INREC IFTHEN=(WHEN=GROUP,
...

nithyakothai:

I see that someone has reformatted your post so that the "mem#" records now all appear at the same position in the record.
In order to use INREC/OUTREC IFTHEN WHEN=GROUP pr ...

nithyakothai:

Your posting displays the second and third input records as containing fields starting in position 01 with the data "mem2" and "mem3". In your first input record t ...

JMCrockett:

Please try the following (requires SyncSort for z/OS Release 1.3):

//SYSIN DD *
SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=(8,1,BI,NE,B'....1..1',OR,
8,1,BI,EQ, ...

PARSE is not supported in a product as old as SyncSort MVS 3.7 (TPF4). There is no mechanism in SyncSort MVS 3.7 (TPF4) to accompish what you ask.

batu544:
I used the following SyncSort control statements:

//STEP01 EXEC PGM=SORT
//SORTOUT DD SYSOUT=*
//SORTIN DD * ...

tcurrier:

To comment out a control statement using SyncSort, place an asterisk (*) in column 1.

tcurrier:

Thanks for the update. I try not to hard-code the DCB in my JCL so I automatically got FBA. The 'A' refers to ANSI control character, which controls things like printer line feeds. By rem ...

tcurrrier:

Starting with the very helpful coding example offered by Frank, I was able to get the expected results using SyncSort for z/OS 1.3.2.1 by removing the 'REMOVECC' parameter from the OUTFI ...

MF:

I have restricted the below coding example to the specifics of your latest posting. I have coded an OUTFIL statement which uses IFTHEN to detect if the byte in position 16 is a blank; if it is ...

rkarthik22:

Please email me a copy of the complete job listing (JCL, JES LOG, SYSOUT containing SyncSort message output) to review.

prog_mario:

At this time, SyncSort does not have a special function to perform arithmetic on input date fields.

rk_pulikonda:

The WER268A syntax error message indicates that you are using an older level of SyncSort for z/OS that does not include support for WHEN=GROUP. Support for WHEN=GROUP was included in ...