APICP settings in tsql

miker · Post by **miker** » Thu May 17, 2001 10:45 am

I'm trying to run an intelligent query, I don't really care how long it takes, I'm just looking for the most accurate matches based on the meanings of the search words. From what I can tell I need to change some APICP settings to make this work.

My query is simple
SELECT docid FROM textrep WHERE text LIKEP 'water contamination of ecoli'

I'm not finding anywhere near the accuracy I had hoped for and I expect that I've messed up the query or some other setting that's not causing the search to go as expected. The docs seem to point toward the APICP settings to make it do morpheme and other assorted magic on the query.

Post by **mark** » Thu May 17, 2001 11:23 am

tsql is an adhoc utility for doing quick queries and such. Not all settings may be changed with it. For full control over all settings you need to write a short vortex script. There you may adjust all of the apicp parameters.

Post by **mark** » Thu May 17, 2001 11:24 am

p.s.
Also, depending on your needs, consider using like instead of likep.

Post by **John** » Thu May 17, 2001 11:56 am

If you search the Texis documentation for "Server Properties" you will find those settings which can be changed with a SQL "set property=value" statement. Tsql also has a -r option to read in a profile with other settings such as noise words and suffix lists.