Basic example of how to use the Basic Text Search (BTS) soundex analyzer

Technote (FAQ)


Question

How do you use the BTS soundex analyzer?

Answer

Here are the basic steps needed to setup and use the BTS soundex analyzer. This document assumes you know and have satisfied the basic requirements of the BTS blade like having a BTS vp running, existing smart blob space, and so on.

create table test (
c1 serial,
c2 char(30)
);

contents of test.unl
0|great|
0|grate|
0|heard|
0|whether|
0|weather|

load from test.unl insert into test;

create index test_soundex on test (c2 bts_char_ops)
USING BTS (analyzer="soundex") in smartblobspace1;


select * from test where
bts_contains(c2, 'great')

c1 c2

1 great
2 grate

select * from test where
bts_contains(c2, 'weather')


c1 c2

4 whether
5 weather

select * from test where
bts_contains(c2,'herd')

c1 c2

3 heard

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

11.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1573774

Modified date:

2011-11-30

Translate my page

Machine Translation

Content navigation