Relate can read input records from an SQL database instead of a file. In order to do this you must:
Define source table(s) in the
UST
Section of the SDF using the
define_source
clause.
Create a
Logical-File Definition
with
INPUT-FORMAT=SQL
Run Relate with the input file parameter set to
"lfile=xxx"
where
xxx
is the name of the Logical- File Definition.
The source definition should match the layout of the IDT (same field names, offsets and lengths). If it does not, specify an input view so that the Search Server will convert the input record into IDT format prior to searching. Note that a
define_source
clause automatically creates an input-view with the same name as the source.