IBM Mainframe Forum

by **GUI1504** » Tue Sep 14, 2010 6:18 pm

Hello people! I'm need to merge 3 tables, but i can't...i've got MAXCC=16 and this message in SYSOUT: ICE068A 0 OUT OF SEQUENCE SORTIN03 . I've already received this message, but with SORTIN01, so i've changed my MERGE FIELDS to (22,32,CH,A,5,2,CH,A,14,8,CH,A,75,4,CH,A,88,4,CH,A), and now I don't know how to proceed

MERGE

Select all

//MERGE EXEC PGM=SORT
//SORTIN01 DD DSN=GUI1504.POCITS.ARQ1,DISP=SHR
//SORTIN02 DD DSN=GUI1504.POCITS.ARQ2,DISP=SHR
//SORTIN03 DD DSN=GUI1504.POCITS.ARQ3,DISP=SHR
//SORTOUT DD DSN=GUI1504.POCITS.ARQ,DISP=(,CATLG,DELETE),
// SPACE=(133,(80,30),RLSE)
//SYSOUT DD SYSOUT=*
//SYSIN DD *
OPTION VLSHRT
MERGE FIELDS=(22,32,CH,A,5,2,CH,A,14,8,CH,A,75,4,CH,A,88,4,CH,A)
/*

SYSOUT

Select all

ICE143I 0 BLOCKSET MERGE TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 08:38 ON TUE SEP
OPTION VLSHRT
MERGE FIELDS=(22,32,CH,A,5,2,CH,A,14,8,CH,A,75,4,CH,A,88,4,CH,A)
ICE201I 0 RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE751I 0 C5-BASE C6-BASE C7-BASE C8-Q83041 E9-BASE C9-BASE E5-Q90312
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED
ICE088I 0 GUI1504M.MERGE . , INPUT LRECL = 133, BLKSIZE = 6233, TYPE =
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6234096,6234096)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,
ICE128I 0 OPTIONS: SIZE=6291456,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERE
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=
ICE132I 0 OPTIONS: VLSHRT=Y,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE ,EXITC
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMI
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN01
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN02
ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN03
ICE068A 0 OUT OF SEQUENCE SORTIN03
ICE751I 1 DC-Q91626 DD-Q84357 E8-Q91626
ICE052I 0 END OF DFSORT

JESYSMSG

Select all

ICH70001I GUI1504 LAST ACCESS AT 08:34:30 ON TUESDAY, SEPTEMBER 14, 2010
IEF236I ALLOC. FOR GUI1504M MERGE
IGD103I SMS ALLOCATED TO DDNAME SORTIN01
IGD103I SMS ALLOCATED TO DDNAME SORTIN02
IGD103I SMS ALLOCATED TO DDNAME SORTIN03
IGD101I SMS ALLOCATED TO DDNAME (SORTOUT )
DSN (GUI1504.POCITS.ARQ )
STORCLAS (USER) MGMTCLAS ( ) DATACLAS ( )
VOL SER NOS= FUSR1C
IEF237I JES2 ALLOCATED TO SYSOUT
IEF237I JES2 ALLOCATED TO SYSIN
IEF142I GUI1504M MERGE - STEP WAS EXECUTED - COND CODE 0016
IGD104I GUI1504.POCITS.ARQ1 RETAINED, DDNAME=SORTIN01
IGD104I GUI1504.POCITS.ARQ2 RETAINED, DDNAME=SORTIN02
IGD104I GUI1504.POCITS.ARQ3 RETAINED, DDNAME=SORTIN03
IGD104I GUI1504.POCITS.ARQ RETAINED, DDNAME=SORTOUT
IEF285I GUI1504.GUI1504M.JOB22367.D0000102.? SYSOUT
IEF285I GUI1504.GUI1504M.JOB22367.D0000101.? SYSIN
IEF373I STEP/MERGE /START 2010257.0838
IEF374I STEP/MERGE /STOP 2010257.0838 CPU 0MIN 01.08SEC SRB 0MIN 00.13S
IEF375I JOB/GUI1504M/START 2010257.0838
IEF376I JOB/GUI1504M/STOP 2010257.0838 CPU 0MIN 01.08SEC SRB 0MIN 00.13S

by **Frank Yaeger** » Tue Sep 14, 2010 10:39 pm

As the message indicates, each file must be in sorted order by

(22,32,CH,A,5,2,CH,A,14,8,CH,A,75,4,CH,A,88,4,CH,A)

and one or more aren't.

The messages include:

ICE201I 0 RECORD TYPE IS V - DATA STARTS IN POSITION 5

so your input files are VB. That means you have to include the RDW in the starting positions - the first data byte starts in position 5, not position 1. If you didn't include the RDW in the starting positions, you need to add 4 to each starting position:

(26,32,CH,A,9,2,CH,A,18,8,CH,A,79,4,CH,A,92,4,CH,A)

If each VB file is already sorted by those fields, then the MERGE will work.

If the files are really not sorted, then you can either concatenate the three files and sort them, or sort each individual file and then merge them.

by **GUI1504** » Tue Sep 21, 2010 12:18 am

I can do it works!

I have to sort each separated file in (5,124,CH,A), and after merge them

Thank you

IBM Mainframe Forum

[PROBLEM] Using MERGE

[PROBLEM] Using MERGE

Re: [PROBLEM] Using MERGE

Re: [PROBLEM] Using MERGE