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

None

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
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0