Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Breaks a CHAR string into terms and returns each term as a row along with its position.
sa_char_terms( 'text' [, 'config-name' [, 'owner' ] ]
The CHAR string you are parsing.
The text configuration object to apply when processing the string. The default value is 'default_char'.
The owner of the specified text configuration object. The default value is DBA.
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.
The following statement returns the terms in the CHAR string, It's a work-at-home day!, using the default CHAR text configuration
CALL sa_char_terms ('It''s a work-at-home day!', 'default_char', 'sys');