Guest.Visitor
05-01-2002, 05:04 AM
Hello all, I am looking for a way to create an idex on a virtual field so I can SetLL on it in my program. What I am ultimately trying to accomplish is a soundex search over some of our files using an RPG program. I want to be able to do this without modifying the files and we have no field setup to hold soundex codes. I was wondering if I could do something with an OPNQRYF and MAPFLD. We have a LF keyed by name and if I could somehow do an OPNQRYF over a SQL view, create a virtual soundex field and map the value to the name field in the existing LF record format I could possibly use this. Has anybody ever done anything even remotely close to what I'm attempting? Cliff