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' ] ]  ] 
)
Arguments
  • 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.

Remarks

You can use this system procedure 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

Side effects

None

See also
Example

The following statement returns 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' );
term position
the 1
quick 2
brown 3
fox 4
jumped 5
over 6
the 7
fence 8