Home > IT Answers > AS/400 > Alternate Collating Sequence
Intravler
0 pts.
 Alternate Collating Sequence
AS/400, DB2 Universal Database, RPG
I have a logical file keyed by email address and defined with ALTSEQ and dynamic select/omit. My problem is if I perform a READEQ for a specific key value, only records with lower-case keys are returned. I expected the upper-case entries to also be returned. Can anyone shed any light on why this might occur and how I might correct the problem? Thanks for any and all assistance.

Software/Hardware used:
ASKED: October 9, 2006  3:26 PM
UPDATED: December 24, 2009  10:39 AM
RELATED QUESTIONS
Answer Wiki:
The problem is that ALTSEQ only changes the order in which records are returned. It will not make 'A' = 'a'. To do that you need the TRNTBL keyword to force one or more fileds on all records (in that logical only) to be returned as upper or lower case. There is a system supplied table QSYSTRNTBL which forces everything to upper case so you couuld use this to map all the email addresses to uppercase so that you can match all regardless of case. I don't think there is a system supplied forced lower case table, so if you wanted that you'd have to create your own translation table.
Last Wiki Answer Submitted:  October 10, 2006  7:56 am  by  Alasdair727   0 pts.
All Answer Wiki Contributors:  Alasdair727   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What table did you specify for ALTSEQ? What are your Select/Omit criteria?

Tom

TomLiotta
 108,260 pts.