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 required.

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

View any text object configuration property page – None required.

Modify a text configuration object term breaker or external prefilter property – Requires:
  • CREATE ANY EXTERNAL REFERENCE system privilege.
  • Also requires 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 – Requires 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 – Requires 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, select IQ Servers > Schema Objects > Text Configuration.
  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 modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
    • If you do not have privileges to modify properties, Sybase 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. Click OK.
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