Home

	Expand Search

Full-Text Search Specialty Data Store User's Guide

About This Book

About This Book

This book explains how to use the Full-Text Search Specialty Data Store product with Sybase(R) Adaptive Server(TM) Enterprise. Although this book refers to Adaptive Server throughout, the instructions for using it with OmniConnect(TM) are the same.

There are two versions of the Full-Text Search Specialty Data Store:

• The Standard version is included with your purchase of Adaptive Server Enterprise
• The Enhanced version is purchased separately and has additional capabilities

This book describes the features and functionality of both versions.

Audience

This book is for System Administrators who are configuring Adaptive Server for a Full-Text Search Specialty Data Store and for users who are performing full-text searches on Adaptive Server data.

How to Use This Book

This book includes the following chapters:

• Chapter 1, "Introduction," provides an overview of Full-Text Search Specialty Data Store.
• Chapter 2, "Understanding the Full-Text Search Engine," describes the components of the Full-Text Search Specialty Data Store and how it works.
• Chapter 3, "Configuring Adaptive Server for Full-Text Searches," describes how to configure Adaptive Server so that Full-Text Search Specialty Data Store can perform full-text searches on the Adaptive Server databases.
• Chapter 4, "Setting Up Verity Functions," describes the setup you need to do before issuing full-text search queries.
• Chapter 5, "Writing Full-Text Search Queries," describes the components you use to write full-text search queries.
• Chapter 6, "System Administration," provides information about system administration issues.
• Chapter 7, "Performance and Tuning," provides information about performance and tuning issues.
• Appendix A, "System Procedures," describes Full-Text Search Specialty Data Store system procedures.
• Appendix B, "Sample Files," contains the text of the textsvr.cfg file, describes the sample files included with Full-Text Search Specialty Data Store, and discusses issues regarding the sample_text_main.sql script.
• Appendix C, "Unicode Support," describes how to configure Full-Text Search Specialty Data Store to use Unicode.

Adaptive Server Enterprise Documents

The following documents comprise the Sybase Adaptive Server Enterprise documentation:

• The Installation and Release Bulletin for your platform - contains instructions on how to install Enhance Full-Text Search Specialty Data Store, how to configure a Full-Text Search engine, and last-minute information that was too late to be included in the books.

  A more recent version of the Installation and Release Bulletin may be available on the World Wide Web. To check for critical product or document information that was added after the release of the product CD, use Sybase Technical Library on the Web.

• The Adaptive Server installation documentation for your platform - describes installation and upgrade procedures for all Adaptive Server and related Sybase products.
• The Adaptive Server configuration documentation for your platform - describes configuring a server, creating network connections, configuring for optional functionality, such as auditing, installing most optional system databases, and performing operating system administration tasks.
• New Functionality in Adaptive Server 11.9.2 - describes the new features in Adaptive Server release 11.9.2, the system changes added to support those features, and the changes that may affect your existing applications.
• What's New in Adaptive Server Enterprise? - describes the new features in Adaptive Server release 11.5, the system changes added to support those features, and the changes that may affect your existing applications.
• Navigating the Documentation for Adaptive Server - an electronic interface for using Adaptive Server. This online document provides links to the concepts and syntax in the documentation that are relevant to each task.
• Transact-SQL User's Guide - documents Transact-SQL(R), Sybase's enhanced version of the relational database language. This manual serves as a textbook for beginning users of the database management system. This manual also contains descriptions of the pubs2 and pubs3 sample databases.
• System Administration Guide - provides in-depth information about administering servers and databases. This manual includes instructions and guidelines for managing physical resources and user and system databases, and specifying character conversion, international language, and sort order settings.
• Adaptive Server Reference Manual - contains detailed information about all Transact-SQL commands, functions, procedures, and datatypes. This manual also contains a list of the Transact-SQL reserved words and definitions of system tables.
• Performance and Tuning Guide - explains how to tune Adaptive Server for maximum performance. This manual includes information about database design issues that affect performance, query optimization, how to tune Adaptive Server for very large databases, disk and cache issues, and the effects of locking and cursors on performance.
• The Utility Programs manual for your platform - documents the Adaptive Server utility programs, such as isql and bcp, which are executed at the operating system level.
• Security Administration Guide - explains how to use the security features provided by Adaptive Server to control user access to data. This manual includes information about how to add users to Adaptive Server, administer both system and user-defined roles, grant database access to users, and manage remote Adaptive Servers.
• Security Features User's Guide - provides instructions and guidelines for using the security options provided in Adaptive Server from the perspective of the non-administrative user.
• Error Messages and Troubleshooting Guide - explains how to resolve frequently occurring error messages and describes solutions to system problems frequently encountered by users.
• Component Integration Services User's Guide for Adaptive Server Enterprise and OmniConnect - explains how to use the Adaptive Server Component Integration Services feature to connect remote Sybase and non-Sybase databases.
• Adaptive Server Glossary - defines technical terms used in the Adaptive Server documentation.
• Master Index for Adaptive Server Publications - combines the indexes of the Adaptive Server Reference Manual, Component Integration Services User's Guide, Performance and Tuning Guide, Security Administration Guide, Security Features User's Guide, System Administration Guide, and Transact-SQL User's Guide.

Other Sources of Information

Use the Sybase Technical Library CD and the Technical Library Web site to learn more about your product:

• Technical Library CD contains product manuals and technical documents and is included with your software. The DynaText browser (included on the Technical Library CD) allows you to access technical information about your product in an easy-to-use format.

  Refer to the Technical Library Installation Guide in your documentation package for instructions on installing and starting Technical Library.

• Technical Library Web site is an HTML version of the Technical Library CD that you can access using a standard Web browser.

  To use the Technical Library Web site, go to www.sybase.com and choose Documentation, choose Technical Library, then choose Product Manuals.

Conventions

Directory Paths

For readability, directory paths in this manual are in UNIX format. On Windows NT, substitute $SYBASE with %SYBASE% and replace slashes (/) with backslashes (\). For example, replace this user input:

$SYBASE/sds/text/scripts

with:

%SYBASE%\sds\text\scripts

Formatting SQL Statements

SQL is a free-form language: there are no rules about the number of words you can put on a line or where you must break a line. However, for readability, all examples and syntax statements in this manual are formatted so that each clause of a statement begins on a new line. Clauses that have more than one part extend to additional lines, which are indented.

SQL Syntax Conventions

The conventions for syntax statements in this manual are as follows:

Table 1: Syntax statement conventions

Key	Definition
command	Command names, command option names, utility names, utility flags, and other keywords are in bold Courier in syntax statements and in bold Helvetica in paragraph text.
variable	Variables, or words that stand for values that you fill in, are in italics.
{ }	Curly braces indicate that you choose at least one of the enclosed options. Do not include braces in your option.
[ ]	Brackets mean choosing one or more of the enclosed options is optional. Do not include brackets in your option.
( )	Parentheses are to be typed as part of the command.
|	The vertical bar means you may select only one of the options shown.
,	The comma means you may choose as many of the options shown as you like, separating your choices with commas to be typed as part of the command.

• Syntax statements (displaying the syntax and all options for a command) are printed like this:

  sp_dropdevice [device_name]

  or, for a command with more options:

  select column_name 
      from table_name 
      where search_conditions 

  In syntax statements, keywords (commands) are in normal font and identifiers are in lowercase: normal font for keywords, italics for user-supplied words.

• Examples showing the use of Transact-SQL commands are printed like this:

  select * from publishers

• Examples of output from the computer are printed like this:

  pub_id        pub_name                        city            state 
  -------        -------------------                        -----------            -----
  0736        New Age Books                        Boston            MA 
  0877        Binnet & Hardley                        Washington            DC 
  1389        Algodata Infosystems                        Berkeley            CA 
  
  (3 rows affected)

Case

In this manual, most of the examples are in lowercase. However, you can disregard case when typing Transact-SQL keywords. For example, SELECT, Select, and select are the same.

Adaptive Server's sensitivity to the case of database objects, such as table names, depends on the sort order installed on Adaptive Server. You can change case sensitivity for single-byte character sets by reconfiguring the Adaptive Server sort order. See "Changing the Default Character Set, Sort Order, or Language" in Chapter 19 of the System Administration Guide for more information.

Obligatory Options {You Must Choose At Least One}

• Curly Braces and Vertical Bars: Choose one and only one option.

  {die_on_your_feet | live_on_your_knees |
  live_on_your_feet}

• Curly Braces and Commas: Choose one or more options. If you choose more than one, separate your choices with commas.

  {cash, check, credit}

Optional Options [You Don't Have to Choose Any]

• One Item in Square Brackets: You don't have to choose it.

  [anchovies]

• Square Brackets and Vertical Bars: Choose none or only one.

  [beans | rice | sweet_potatoes]

• Square Brackets and Commas: Choose none, one, or more than one option. If you choose more than one, separate your choices with commas.

  [extra_cheese, avocados, sour_cream]

Ellipsis: Do It Again (and Again)...

An ellipsis (...) means that you can repeat the last unit as many times as you like. In this syntax statement, buy is a required keyword:

buy thing = price [cash | check | credit] 
    [, thing = price [cash | check | credit] ]... 

You must buy at least one thing and give its price. You may choose a method of payment: one of the items enclosed in square brackets. You may also choose to buy additional things: as many of them as you like. For each thing you buy, give its name, its price, and (optionally) a method of payment.

If You Need Help

Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.