Re: STRSQL error -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On 8/30/2023 1:49 PM, James H. H. Lampert via MIDRANGE-L wrote:

On 8/30/23 10:43 AM, Buck Calabro wrote:

Look at the CCSIDs . . .

I'd figured it was a CCSID problem (the error message said as much, after all), but I could have sworn there was a place to change that in STRSQL itself.

Sadly, when I changed my job CCSID (from an off-List suggestion), I ended up with:

Message . . . . :   Text search support is not available for reason 3.
Cause . . . . . :   A problem with one of the text search administrative
tables was detected. The reason code is 3.
    1 - One of the text search administrative tables was not found.
    3 - Text search support is not installed.
    4 - Text search support is not started.
    7 - No text search servers have been defined.

Oh, well, STRSQL is hardly the only tool in the box.

This error is because Omnifind is not installed on that machine.
https://www.ibm.com/docs/en/i/7.4?topic=functions-contains

Consider using LIKE rather than CONTAINS, so perhaps

where bar like '%.@%'

https://www.ibm.com/docs/en/i/7.4?topic=predicates-like-predicate

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.