[PROBLEM] Using MERGE



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

[PROBLEM] Using MERGE

Postby 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
//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
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
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
GUI1504
 
Posts: 28
Joined: Fri Sep 03, 2010 10:40 pm
Location: Campinas, SP - Brazil
Has thanked: 0 time
Been thanked: 0 time

Re: [PROBLEM] Using MERGE

 

Re: [PROBLEM] Using MERGE

Postby 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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: [PROBLEM] Using MERGE

Postby 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 :D
GUI1504
 
Posts: 28
Joined: Fri Sep 03, 2010 10:40 pm
Location: Campinas, SP - Brazil
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post