One thing I'm running into more and more as I integrate IBM i back ends with the rest of the world is sort sequences. Upper and lower is one such instance although you can get around that with UPPER at the cost of some performance. A stickier issue is EBCDIC vs ASCII collating, and of course specifically digits and non-digits (although punctuation can be a problem as well).

I'd like to start with simply doing a select with an order by in STRSQL and get records in, say, a case-insensitive ASCII sequence. I'd then like to be able to execute that same query via a traditional ODBC call. However, I'm not sure how to get there. The closest I've seen is a note on creating an SQL INDEX while the session is set to SRTSEQ(*LANGIDSHR). THis seems to be more for case sensitivity than ASCII, but I'm willing to learn. Has anyone done this?


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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].