Syncsort - Splitting records



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

Syncsort - Splitting records

Postby sinmani » Fri Jun 29, 2012 7:30 pm

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??
You do not have the required permissions to view the files attached to this post.
-----------------------------------------
As long as you think you are a student, you are doing well.
The day you consider yourself as the master of the game..........well
sinmani
 
Posts: 93
Joined: Thu Mar 22, 2012 10:02 am
Has thanked: 14 times
Been thanked: 0 time

Re: Syncsort - Splitting records

Postby dick scherrer » Fri Jun 29, 2012 8:06 pm

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?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Syncsort - Splitting records

Postby dick scherrer » Fri Jun 29, 2012 8:10 pm

Follow on:

SPLIT1R=0000001F


Where did this originate? IIRC, this value must be a number. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Syncsort - Splitting records

Postby sinmani » Fri Jun 29, 2012 8:26 pm

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
-----------------------------------------
As long as you think you are a student, you are doing well.
The day you consider yourself as the master of the game..........well
sinmani
 
Posts: 93
Joined: Thu Mar 22, 2012 10:02 am
Has thanked: 14 times
Been thanked: 0 time

Re: Syncsort - Splitting records

Postby dick scherrer » Fri Jun 29, 2012 8:32 pm

Hello,

Did you see my follow on reply . . .?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Syncsort - Splitting records

Postby BillyBoyo » Fri Jun 29, 2012 8:50 pm

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"....
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post