Specifications

Page 24 DocSTAR Level 2 Service Training Workbook
Wildcard characters
* Represents any number of characters
? Represents any single character
# Represents any single digit
Special Values
TRUE/FALSE Represents that the condition is true/false (yes/no, -1/0,
checked/unchecked)
NULL Represents no data present (at times, an invalid condition)
There are certain field names that may require brackets ([ ]) around them when using
them in an SQL statement. Some of these field names are:
Class table
NAME
Document table
CLASS$
ORIGIN$
Miscdata table
DATE
Origin table
NAME
Page table
TEXT
Phone table
NAME
NUMBER
User table
NAME
In order to create an SQL statement that can help you, you must know the DocSTAR
database well enough to know what information you need from it and what information
you want to change in it. A practical application can be seen in the following example:
A DocSTAR customer decided to buy MO disks from an outside source,
against the recommendations of their Authorized DocSTAR Dealer, and
didn’t realize that the Volume Label of each disk was ‘IMATION.’ After
archiving to 3 disks this way they realized that they were having problems
retrieving documents because DocSTAR would keep requesting Volume
‘IMATION’ and there were 3 disks labeled this way. This situation would
require that they try each disk until they loaded the correct one. This would
defeat the main function of DocSTAR, which is fast retrieval of documents.
To correct this situation you would need some information such as, the day
that each volume was created which would be found in the Volume table.
You should use Datamgr.exe to open the Volume table in the database and
collect this information. Upon investigation you find that the first listing of
‘IMATION’ was created on 9/11/1999, the second was created on 1/1/2000,
and the third was created on 3/7/2000. You must now find the Volume that
has image files created between 9/10/1999 and 1/1/2000 and change the
Volume label to ‘VOLUME_0001.’ The next step involves correcting the
document pointers in the DocSTAR database. To correct the first volume
you would use the following:
UPDATE DOCUMENT Updates every record in the document table and
SET Volume_ = “VOLUME_0001” Sets the Volume_ field to “VOLUME_0001”
WHERE Volume_ = “IMATION” Wherever the Volume_ field is “IMATION”