Home

	Expand Search

Full-Text Search Specialty Data Store User's Guide

Appendix A: System Procedures

Appendix A

This appendix describes the Sybase-supplied system procedures used for updating and getting reports from system tables. Table A-1 lists the system procedures included with the Full-Text Search engine.

Table A-1: System procedures

Procedure	Description
sp_clean_text_events	Removes entries from the text_events table.
sp_clean_text_indexes	Cleans up stray indexes.
sp_create_text_index	Creates an external text index.
sp_drop_text_index	Drops text indexes.
sp_clean_text_events	Removes processed entries from the text_events table.
sp_help_text_index	Enhanced version only. Displays text indexes.
sp_optimize_text_index	Enhanced version only. Runs the Verity optimization routines.
sp_redo_text_events	Changes the status of entries in the text_events table and forces re-indexing of the modified table.
sp_refresh_text_index	Adds an entry to the text_events table for the update to a source table.
sp_show_text_online	Displays information about databases or indexes that are currently online.
sp_text_cluster	Enhanced version only. Displays or modifies clustering options.
sp_text_configure	Enhanced version only. Displays or modifies Full-Text Search engine configuration parameters.
sp_text_dump_database	Enhanced version only. Makes a backup copy of the text indexes in a database and optionally dumps the text_db and current databases.
sp_text_kill	Enhanced version only. Terminates all connections to a text index.
sp_text_load_index	Enhanced version only. Restores text indexes from a backup.
sp_text_notify	Notifies the Full-Text Search engine that the text_events table has been modified.
sp_text_online	Makes a database available to Adaptive Server.

sp_clean_text_events

sp_clean_text_indexes

sp_create_text_index

sp_drop_text_index

sp_help_text_index

sp_optimize_text_index

sp_redo_text_events

sp_refresh_text_index

sp_show_text_online

sp_text_cluster

sp_text_configure

sp_text_dump_database

sp_text_kill

sp_text_load_index

sp_text_notify

sp_text_online