Re: Sequence error in MR -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Gary Kuznitz wrote:

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?

If I'm not mistaken, I believe the match fields logic compares match fields using a straight hex comparison. That is, "Abiah" compares less than "ABEL E" (EBCDIC), even thought data management serves up the latter key first.

The match fields logic does take the alternate collating sequence into account, and so if you want lower and upper case alphabetics to compare equal, you can code an altseq table. (But I'm sure there's a better solution using just DDS or SQL.)

Cheers! Hans

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.