our of sequence error



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

our of sequence error

Postby Savita » Fri Apr 16, 2010 11:19 pm

Hi,

can any body tell me the possible reasons of getting "out of sequence" error while merging files...
one of the reason I know is duplication, but in my file there is not duplicate data still I am getting this error and I am not able to find the reason.
Savita
 
Posts: 7
Joined: Wed Aug 19, 2009 11:43 pm
Has thanked: 0 time
Been thanked: 0 time

Re: our of sequence error

Postby skolusu » Fri Apr 16, 2010 11:32 pm

Savita,

MERGE automatically checks the sequence of the input records and issues ICE068A if the records are out of sequence. If you are getting the error then your files/datasets are NOT sorted in the required order

If the files are not already in sorted order, just SORT the concatenated files instead of doing a MERGE on the individual files.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: our of sequence error

Postby Frank Yaeger » Sat Apr 17, 2010 12:59 am

Duplication is NOT a reason for an out of sequence error.

For a MERGE, the records in each SORTINnn file must already be in the order you specify in your MERGE statement. If not, you will get the out of sequence error.
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: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post