we have a PF and a LF that utilizes ALTSEQ(QSYSTRNTBL) for case insensitive searches.
What is the least invasive path to change the PF to a table, and utilize an index that uses upper() and has the most minimal impact to the application layer where the current LF is currently used?
I'm thinking...
1.) convert PF to table (as-is)
2.) convert the LF to the index but create new columns ( upper(column) as newcolumn) and change the applications to look at this newcolumn.
Is there a less invasive path?
What is the least invasive path to change the PF to a table, and utilize an index that uses upper() and has the most minimal impact to the application layer where the current LF is currently used?
I'm thinking...
1.) convert PF to table (as-is)
2.) convert the LF to the index but create new columns ( upper(column) as newcolumn) and change the applications to look at this newcolumn.
Is there a less invasive path?
Comment