Text Search


I am trying to determine the best way to search through a string stored in a custom table. I was able to write an application that does that using the wildcard search and a runtime select filter but I'm not thrilled with the performance.

I started looking into using Text Search but I seem to be stuck. I created a business view, checked the Text Search checkbox and added Generic Text data structure to it. I added the business view to P95820A. When I try to run a full build in P95800A, the record turns to 3 (In Error). Also, I'm getting a JAS error in my application that is using a Text Search control. Any ideas? Thanks in advance!

JDE E1 9.0/
IBM iSeries V7R1