Operations Guide

Back Next

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, use the

-i

switch to specify an input view so that the Search Server will convert the input record into IDT format prior to searching.

define_source

clause automatically creates an input-view with the same name as the source.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.