Re: Sequence error in MR

Hi Doug,

Great catch.  But I don't know if this is the answer.  The file KAISXMITL1 does 
not have a descending index or is case-insensitive.  The file KAISLISTL1 is 
case-insensitive.  I ran this in debug and found no records have been read from 
the file KAISLISTL1.  The record the program is looking at from the file 
KAISXMITL1 is "ABEL E".  The next record in the file is "Abiah".  The dump 
shows all blanks in the FirstNameL field coming from KAISLISTL1 which means it 
didn't read a record yet because there are no records with a blank in 
FirstNameL .  It's acting like the case-insensitive is on the wrong file.  Is 
there a way I can have the LF treet the field as uppercase?

Gary Kuznitz


> Gary,
> 
> > Message . . . . :   The match field for file KAISXMITL1 is out of sequence 
> 
> Does this file have the collating sequence changed?  Perhaps to be
> case-insensitive or something?  Or is the index descending?
> 
> The RPG program is reading KAISXMITL1 by key yet complaining the match field 
> is
> out of sequence.  The two most likely causes I can see are a descending index 
> on
> the file (in which case use D instead of A for both match files), or the index
> using a case-insensitive index or otherwise varying from what RPG expects.
> 
> You can always take the F option or run it in debug to see the last key value
> processed in KAISXMITL1.  Then display the file in key order and see what key
> value comes after the key in the dump.
> 
> Doug