I haven't used this before, but in theory it should work:
Use the TRNTBL() keyword on the appropriate field and specify the QSYS/QSYSTRNTBL as the table to use. It's purpose is to translate lower to upper case.
I have a field that contains upper and lower case (it may not much longer if this keeps up.) When this data was on the PC they were able to search on smith' and find smith', Smith', SMITH', or any other variation. I can do the same thing in SQL by using UCASE on what the search string as well as the field coming from the PF. But it's slow. I can't find any way to simulate UCASE in a DDS key field and UCASE either can't be used with SQL create index or I'm not getting the syntax down. Can anyone help?