Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. System Backup and Restore
  13. Batch Utilities

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, 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.
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!