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?