Viewing or Modifying Text Configuration Object Properties

Display and change the properties of a text configuration object for a text index.

Prerequisites
Database Version Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4

View any text object configuration property page – none.

Modify any text object configuration property – you must have one of:
  • DBA authority
  • You own the text configuration object
SAP Sybase IQ 16.0

View any text object configuration property page – none.

Modify a text configuration object term breaker or external prefilter property – you must have the CREATE ANY EXTERNAL REFERENCE system privilege. You must also have one of:
  • ALTER ANY TEXT CONFIGURATION system privilege
  • ALTER ANY OBJECT system privilege
  • You own the text configuration object
Modify a text configuration object comment – you must have one of:
  • CREATE ANY TEXT CONFIGURATION system privilege
  • ALTER ANY TEXT CONFIGURATION system privilege
  • CREATE ANY OBJECT system privilege
  • ALTER ANY OBJECT system privilege
  • COMMENT ANY OBJECT system privilege
  • You own the text configuration
Modify any other text configuration object properties – you must have one of:
  • ALTER ANY TEXT CONFIGURATION system privilege
  • ALTER ANY OBJECT system privilege
  • You own the text configuration object
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects, and then select Text Configuration Objects.
  3. Select a text configuration from the right pane and either:
    • Click the arrow to the right of the name and select Properties, or
    • From the Administration Console menu bar, select Resource > Properties.
    The Text Configuration Properties view appears.
  4. View or modify the properties.
    Note:
    • When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
    • If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.
    Area Description
    General

    Name – (Read-only) The name of the text configuration.

    Type – (Read-only) The type of object.

    Owner – (Read-only) The owner of the text configuration object.

    Collation sequence – (Read-only) Type of database collation. Default value is ISO_BINENG. Valid entries are:

    • ISO_BINENG – Binary ordering, English ISO/ASCII 7-bit letter case mappings
    • UCA – Standard default Unicode Collation Algorithm collation

    Comment – A text field for adding an optional comment about the text configuration.
    Settings

    Which term breaker algorithm should be used? – Select Generic or N-gram.

    What is the minimum term length? – Valid entries are:
    • For Generic - Valid range is 1-60. Default value is 1.
    • For N-gram - Not available.
    What is the maximum term length? – Valid entries are:
    • For Generic - Valid range is 1-60. Default value is 20.
    • For N-gram - Valid range is 1-60. Default value is 4.

    Use an external term breaker? — Available only if Collation sequence is ISO_BINENG and Generic term breaker algorithm are selected.

    Specify the external term breaker function and library — Specify an external library function to break the text into terms, using one of these formats:
    • function-name@library-file-name
    • Windows-function-name@library-file-name.dll
    • UNIX:UNIX-function-name@library-file-name.so

    Use an external prefilter — Available for ISO_BINENG collation sequence only.

    Specify the external prefilter function and library — Available for ISO_BINENG collation sequence only.
    Stoplist

    Indicate the terms to be ignored when building a text index.

    Sort Terms — Click to sort the term list.

    Options

    (Read-only)

    The option settings the text configuration object was created with.
  5. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Parent topic: Text Configuration Objects
Related tasks
Creating a Text Configuration Object
Deleting a Text Configuration Object
Generating Text Configuration Object DDL Commands
Authenticating a Login Account for a Managed Resource
Related reference
Text Configuration Privilege Summary