Download User Manual

>if
spaces}
long="abcde"
{Suprtool checks for trailing
Suprtool accepts the null string. Suprtool pads it with spaces, so this is an easy way
to see if a field is blank:
>if name = ""
{if name is blank}
One problem with any tool that accepts strings is how to include a quote mark inside
the string. Suprtool offers two solutions:
1. Use the opposite quote mark (e.g., "don't").
2. Whenever two quote marks appear in a string, they are treated as a single quote
(e.g., 'don''t').
Subscript
A subscript is used to specify one-of-many fields in a repeated item. Within IMAGE
it is possible to specify repeated fields. For example:
costs,
5J2;
The item COSTS consists of five double integers. You select one element of a
compound field by specifying a subscript in parentheses (the first element is 1, not
0). For example, if you wanted to select the input records where the second cost was
greater than 10000, you would use:
>if costs(2) > 10000
The (2) portion of the command is the subscript. The default subscript is the first
sub-item for Total, Define, Sort, and If, but the entire compound item for Extract.
Table does not allow subscripts -- it always uses (1). The If command has another
syntax, using up to three subscripts, allowing you to refer to subfields without Define
(see the If command for details).
Tables
Tables are created with the Table command and they are used for testing in the If and
Chain commands. Tables are used by the $lookup function of the If command. Use
tables when you wish to check a data field for many different test values. You may
also use tables to specify the records to search for with the Chain command.
Table can also mean a table from an SQL database.
Third-Party Indexing
In MPE/iX 4.0, Hewlett-Packard added support for third-party indexing (TPI) to
TurboIMAGE/XL. TPI is a seamless interface to the indexing products of Dynamic
Information Systems Corporation (DISC) and Bradmark Technologies Inc. Their
products, Omnidex and Superdex, respectively offer generic and keyword search
capabilities, through the standard interface in TurboIMAGE/XL.
TPI is only available to users on MPE/iX 4.0 or later. The database must be indexed
using either Omnidex or Superdex, and must be enabled for indexing using
DBUTIL.
If a database has TPI enabled, Suprtool can take advantage of the generic search
capability in the Chain command. The Form command shows the third-party indexes
that correspond to IMAGE fields and any byte-type indexes that do not correspond to
Doc-To-Help Standard Template
Glossary of Terms • 457