Page 1 of 1

Syncsort - Splitting records

PostPosted: Fri Jun 29, 2012 7:30 pm
by sinmani
Split.JPG


I want to split my input file int 4 output files.
I don't know the number of records in the input file.
The utility should calculate the total number of records, say N
Based on this number it should split the file by N/4 into the 4 files such that first 1 to N/4 go in the first file.
Next N/4 records should go in second file and so on.

I have used the jobs as shown but it gives me error

CTL3CNTL :
OUTFIL FNAMES=(OUT01,OUT02,OUT03),
SPLIT1R=0000001F
*
WER428I CALLER-PROVIDED IDENTIFIER IS "0003"
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000


Could somene please help me out with this??

Re: Syncsort - Splitting records

PostPosted: Fri Jun 29, 2012 8:06 pm
by dick scherrer
Hello,

Which release of Syncsort is being used?

Suggest you post all of the informational and diagnostic messages (includeing message ids) from the problem run.

Is there some reason the code/jcl you posted was not the complete submitted job?

Re: Syncsort - Splitting records

PostPosted: Fri Jun 29, 2012 8:10 pm
by dick scherrer
Follow on:

SPLIT1R=0000001F


Where did this originate? IIRC, this value must be a number. . .

Re: Syncsort - Splitting records

PostPosted: Fri Jun 29, 2012 8:26 pm
by sinmani
SYNCTOOL RELEASE 1.6.2 - COPYRIGHT 2007 SYNCSORT INC.

===========================================================

SYNCSORT FOR Z/OS 1.3.2.1RI U.S. PATENTS: 4210961, 5117495 (C) 2007 SYNCSO
z/OS 1.12.0
SYNCSORT LICENSED FOR CPU SERIAL NUMBER xxxxx, MODEL 2817 747 LICEN
CTL2CNTL :
OUTREC IFOUTLEN=1998,
IFTHEN=(WHEN=INIT,BUILD=(1:1,8,ZD,DIV,+3,
TO=ZD,LENGTH=8)),
IFTHEN=(WHEN=(1,8,ZD,GT,+0),
BUILD=(2X,C'SPLIT1R=',1,8)),
IFTHEN=(WHEN=NONE,
BUILD=(2X,C'SPLIT1R=1'))
PARMLIST :
OPTION RESINV=0,ARESINV=0,MSGDDN=DFSMSG,SORTIN=T1,SORTOUT=C1,SORTDD=CTL2,COPY
WER428I CALLER-PROVIDED IDENTIFIER IS "0002"
WER276B SYSDIAG= 2905386, 6435183, 6435183, 3512025
WER164B 6,884K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,097,336 BYTES USED
WER146B 32K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I T1 : RECFM=FB ; LRECL= 1998; BLKSIZE= 27972
WER237I OUTREC RECORD LENGTH = 1998
WER110I C1 : RECFM=FB ; LRECL= 1998; BLKSIZE= 27972
WER410B 5,856K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
WER410B 0 BYTES RESERVE REQUESTED, 108,400 BYTES USED
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER416B T1 : EXCP'S=1,UNIT=(VIO)
WER416B C1 : EXCP'S=1,UNIT=(VIO)
WER416B TOTAL OF 2 EXCP'S ISSUED FOR COPYING
WER054I RCD IN 1, OUT 1
WER169I RELEASE 1.3 BATCH 0506 TPF LEVEL 2.1
WER052I END SYNCSORT - TFPTSR11,S1,,DIAG=EE00,6082,C22E,00CE,A6C2,488B,8668,44
SYNCSORT FOR Z/OS 1.3.2.1RI U.S. PATENTS: 4210961, 5117495 (C) 2007 SYNCSO
z/OS 1.12.0
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 40BE0, MODEL 2817 747 LICEN
CTL3CNTL :
OUTFIL FNAMES=(OUT01,OUT02,OUT03),
SPLIT1R=0000001F
*
WER428I CALLER-PROVIDED IDENTIFIER IS "0003"
WER268A OUTFIL STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000

Re: Syncsort - Splitting records

PostPosted: Fri Jun 29, 2012 8:32 pm
by dick scherrer
Hello,

Did you see my follow on reply . . .?

Re: Syncsort - Splitting records

PostPosted: Fri Jun 29, 2012 8:50 pm
by BillyBoyo
SYNCSORT LICENSED FOR CPU SERIAL NUMBER 40BE0, MODEL 2817 747             LICEN
CTL3CNTL :
     OUTFIL FNAMES=(OUT01,OUT02,OUT03),
  SPLIT1R=0000001F
                 *
WER428I  CALLER-PROVIDED IDENTIFIER IS "0003"
WER268A  OUTFIL STATEMENT  : SYNTAX ERROR
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000


If you'd used the Code tags it would be easy to show that the problem is exactly what Dick referred to. The error marker (*) is underneath the "F" in your "number"....