Page 1 of 1

our of sequence error

PostPosted: Fri Apr 16, 2010 11:19 pm
by Savita
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.

Re: our of sequence error

PostPosted: Fri Apr 16, 2010 11:32 pm
by skolusu
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.

Re: our of sequence error

PostPosted: Sat Apr 17, 2010 12:59 am
by Frank Yaeger
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.