Table of Contents

Search

  1. Preface
  2. Introduction
  3. Installation
  4. Design
  5. Operation

SQL Input

SQL Input

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.

0 COMMENTS

We’d like to hear from you!