Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Reg: Error while merging.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
muthukannan

New User


Joined: 03 Aug 2006
Posts: 42
Location: Chennai

PostPosted: Sat Jan 05, 2008 3:24 pm    Post subject: Reg: Error while merging.
Reply with quote

Hi,

For the following code:

Code:

//MERGE EXEC PGM=SORT                                   
//SORTIN01 DD DSN=P4030.DFSORT(MERINP1),DISP=SHR,       
//            DCB=(LRECL=80,RECFM=FB)                   
//SORTIN02 DD DSN=P4030.DFSORT(MERINP2),DISP=SHR       
//SORTOUT  DD *                                         
//SYSOUT   DD SYSOUT=*                                 
//SORTDIAG DD DUMMY                                     
//SYSIN    DD *                                         
     MERGE FIELDS=(1,37,CH,A)                           
*    MERGE FIELDS=(39,5,CH,A)                           
//                                                     


Am getting the following error.

Code:

ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                                     
ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K90007 C6-K90007 C7-K90000 C8-K90007 E4-K90007 C9-BASE   E5-K18181
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 - 04:35 ON SAT JAN
               MERGE FIELDS=(1,37,CH,A)                                         
          *    MERGE FIELDS=(39,5,CH,A)                                         
ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K90007 C6-K90007 C7-K90000 C8-K90007 E4-K90007 C9-BASE   E5-K18181
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED   
ICE088I 0 P4030SRT.MERGE   .        , INPUT LRECL = 80, BLKSIZE = 6160, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,4194304,4181086)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (4116544,4100160)                           
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC0 ,VLSCMP=N,SZERO=Y,
ICE128I 0 OPTIONS: SIZE=4194304,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERE
ICE129I 0 OPTIONS: VIO=Y,RESDNT=ALL ,SMF=FULL ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=
ICE130I 0 OPTIONS: RESALL=16384,RESINV=0,SVC=109 ,CHECK=N,WRKREL=Y,OUTREL=Y,CKPT
ICE131I 0 OPTIONS: TMAXLIM=4194304,ARESALL=16384,ARESINV=0,OVERRGN=65536,CINV=Y,
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE    ,EXITC
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=0   ,ODMAXBF=0,SOLRF=N,VLLONG=N,VSAMI
ICE235I 0 OPTIONS: NULLOUT=RC0                                                 
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTOUT                                   
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTIN01                                 
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTIN02                                 
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000                                       
ICE901I 0 N 01PS10 02PS10                                                       
ICE902I 0 O AZ00  I                                                             
ICE068A 0 OUT OF SEQUENCE SORTIN01                                             
ICE751I 1 DC-K10929 DD-Q95174 E8-K19114                                         
ICE052I 0 END OF DFSORT                                                         


From the above error message i understood that my sorting01 file is having some error.

the input file is as follows:

Code:

LIVING WELL ON A SMALL BUDGET             
PICK'S POCKET DICTIONARY                   
INTRODUCTION TO BIOLOGY               BIOL
SUPPLYING THE DEMAND                  BUSIN
STRATEGIC MARKETING                   BUSIN
COMPUTER LANGUAGES                    COMP
VIDEO GAME DESIGN                     COMP
COMPUTERS: AN INTRODUCTION            COMP
NUMBERING SYSTEMS                     COMP
SYSTEM PROGRAMMING                    COMP
INKLINGS: AN ANTHOLOGY OF YOUNG POETS ENGL
EDITING SOFTWARE MANUALS              ENGL
MODERN ANTHOLOGY OF WOMEN POETS       ENGL
THE COMPLETE PROOFREADER              ENGL
SHORT STORIES AND TALL TALES          ENGL
THE INDUSTRIAL REVOLUTION             HIST
EIGHTEENTH CENTURY EUROPE             HIST
CRISIS OF THE MIDDLE AGES             HIST
INTRODUCTION TO PSYCHOLOGY            PSYCH
ADVANCED TOPICS IN PSYCHOANALYSIS     PSYCH



Can someone help me in resolving the error.
Thanks in advance.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10276
Location: italy

PostPosted: Sat Jan 05, 2008 3:36 pm    Post subject: Reply to: Reg: Error while merging.
Reply with quote

Quote:
ICE068A 0 OUT OF SEQUENCE SORTIN01


I wish that before posting everyone would read the program output...

rethoric question..
what are the requirement for a merge

rethoric answer
to have the input files already sorted

Code:
MERGE FIELDS=(1,37,CH,A)


question...
are Your files sorted
Code:
LIVING WELL ON A SMALL BUDGET             
PICK'S POCKET DICTIONARY                   
INTRODUCTION TO BIOLOGY               BIOL
SUPPLYING THE DEMAND                  BUSIN
STRATEGIC MARKETING                   BUSIN
COMPUTER LANGUAGES                    COMP
VIDEO GAME DESIGN                     COMP
COMPUTERS: AN INTRODUCTION            COMP
NUMBERING SYSTEMS                     COMP
SYSTEM PROGRAMMING                    COMP
INKLINGS: AN ANTHOLOGY OF YOUNG POETS ENGL
EDITING SOFTWARE MANUALS              ENGL
MODERN ANTHOLOGY OF WOMEN POETS       ENGL
THE COMPLETE PROOFREADER              ENGL
SHORT STORIES AND TALL TALES          ENGL
THE INDUSTRIAL REVOLUTION             HIST
EIGHTEENTH CENTURY EUROPE             HIST
CRISIS OF THE MIDDLE AGES             HIST
INTRODUCTION TO PSYCHOLOGY            PSYCH
ADVANCED TOPICS IN PSYCHOANALYSIS     PSYCH

answer...
noooo

fix/solution
before a merge operation ... sort the files /datasets in the required order
Code:
ADVANCED TOPICS IN PSYCHOANALYSIS     PSYCH
COMPUTER LANGUAGES                    COMP
COMPUTERS: AN INTRODUCTION            COMP
CRISIS OF THE MIDDLE AGES             HIST
EDITING SOFTWARE MANUALS              ENGL
EIGHTEENTH CENTURY EUROPE             HIST
INKLINGS: AN ANTHOLOGY OF YOUNG POETS ENGL
INTRODUCTION TO BIOLOGY               BIOL
INTRODUCTION TO PSYCHOLOGY            PSYCH
LIVING WELL ON A SMALL BUDGET             
MODERN ANTHOLOGY OF WOMEN POETS       ENGL
NUMBERING SYSTEMS                     COMP
PICK'S POCKET DICTIONARY                   
SHORT STORIES AND TALL TALES          ENGL
STRATEGIC MARKETING                   BUSIN
SUPPLYING THE DEMAND                  BUSIN
SYSTEM PROGRAMMING                    COMP
THE COMPLETE PROOFREADER              ENGL
THE INDUSTRIAL REVOLUTION             HIST
VIDEO GAME DESIGN                     COMP


note... it might have worked with the other merge card...
Back to top
View user's profile Send private message
muthukannan

New User


Joined: 03 Aug 2006
Posts: 42
Location: Chennai

PostPosted: Sat Jan 05, 2008 4:21 pm    Post subject: Reg: Error while merging.
Reply with quote

Thank you so much e.s.


As you said it worked for the other Merge card.
Thanks again.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Sat Jan 05, 2008 10:09 pm    Post subject:
Reply with quote

Quote:
before a merge operation ... sort the files /datasets in the required order


Or if the files are not already in sorted order, just SORT the concatenated files instead of doing a MERGE on the individual files.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us