sa_char_terms System Procedure

Breaks a CHAR string into terms and returns each term as a row along with its position.

Syntax

sa_char_terms( 'char-string' [, 'text-config-name' [, 'owner' ] ] ] 	)

Parameters

char-string – the CHAR string you are parsing.

text-config-name – the text configuration object to apply when processing the string. The default value is 'default_char'.

owner – the owner of the specified text configuration object. The default value is DBA.

Description

You can use sa_char_terms to find out how a string is interpreted when the settings for a text configuration object are applied. This can be helpful when you want to know what terms would be dropped during indexing or from a query string.

Permissions

None.

Example

Return the terms in the CHAR string 'the quick brown fox jumped over the fence':

CALL sa_char_terms
( 'the quick brown fox jumped over the fence' );
CHAR string interpretation

Term

Position

the

1

quick

2

brown

3

fox

4

jumped

5

over

6

the

7

fence

8