Specifications

Page 22 DocSTAR Level 2 Service Training Workbook
DIR.TXT file first. This file is a directory and file listing of
every disk volume that contains DocSTAR documents.
Initialize Main Index Resets only the Full-Text Index to its default state: blank.
This option is used only if the Full-Text Index is missing or
corrupted.
Index Pending Docs Indexes any documents, which have not yet been indexed.
Index Documents Indexes any documents that meet the SQL statement
parameters. With this command you may index part or all of
the documents in a DocSTAR system. The default is to re-
index all of the documents in the DocSTAR system. When
using this command it may be necessary to supply some or
all of the archive disk volumes.
Figure 2.10: Docutil.exe Window
Creating SQL Statements
What are SQL Statements?
Structured Query Language (SQL) statements allow an operator to make many record
modifications in a database in minutes with one well-structured statement, where it might
have taken that same operator hours, days, or even weeks to modify a single record at a
time. The power of an SQL statement can be seen in the following example:
The phone company for New York City had changed area codes for all of
their customers in 4 of the 5 boroughs of New York City. Approximately 5-6
million customers’ phone numbers had to be modified from the 212 area
code to the 718 area code in their customer database. This could either have
been done by many, many data entry operators keypunching the new data
over the course of weeks or even months or one well-structured SQL
statement which updated the customers’ area codes based on the selection
criteria of which borough of New York City they lived in. The SQL statement
could be run by a single unmanned computer for a few days and perform
what otherwise would have been a very daunting, error prone and expensive
task.