Specifications

Printed Documentation
312
Where datasourcename specifies which existing data source stores the
information about how to connect to the desired database. Either a file DSN or
system DSN can be used.
TABLE (short code T)
The TABLE clause is of the form:
TABLE=tablename or T=tablename
Where tablename specifies the name of the table to retrieve data from. If you
wish to use the Variable Table option, enter "??" for the table name.
KEYFIELD (short code K)
The KEYFIELD clause is of the form:
KEYFIELD=fieldname or K=fieldname
Where fieldname specifies the name of the field to be used as a search key.
DATAFIELD (short code D)
The DATAFIELD clause is of the form:
DATAFIELD=fieldname or D=fieldname
Where fieldname specifies the name of the field to be used as printed data.
RECORD (short code R)
The RECORD clause is of the form:
RECORD=string1,string2,string… or R=string1,string2,string….
RECORD specifies the record(s) searched for within the key field.
DIVIDE (short code V)
The DIVIDE clause is of the form:
DIVIDE=”string” or V=”string”
Or DIVIDE=2 or V=2
Where “string” is a text character string that will separate each record. If DIVIDE
is set equal to a number the software will insert that many blank lines after each
record. If no value for DIVIDE is specified, a carriage return will be added to start
the next record on a new line.
The entire string must be enclosed in braces {} and clauses must be separated by
semi colons (;).
Example
ExampleExample
Example
>{N=RISKSAFETY;T=GERMAN;KEY=ID;DATA=PHRASE;R=R2,S17}
For this example the data source name is RISKSAFETY. We are looking in the
GERMAN table under the ID column for R2 and S17. We will then pull out the
data stored in the PHRASE column for those two records. Since we did not
specify a DIVIDER, one carriage return will be added after each record.
Quotes (“”) should be placed around the data source, table, key field, data field,
or record names if they contain any characters other than alphabetic or numeric
characters.