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

XML Input

XML Input

relate
can read input records from a XML file instead of a flat file or SQL database. 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=XML
  • run
    relate
    with the input file parameter set to
    lfile=xxx
    where
    xxx
    is the name of the Logical-File Definition.
The source definition must match the layout of the IDT (same field names, offsets and lengths - and XML tags are case sensitive). If it does not, you can specify an XSLT clause, which is a reference to another XML logical-file-definition, which must be a valid XSLT stylesheet. This can be used to transform the XML input file into the required form.
For example:
logical-file-definition *====================== NAME= lf-relate-xml INPUT-FORMAT= XML PHYSICAL-FILE= "+/data/relate.xml" XSLT= lf-input-stylesheet * logical-file-definition *====================== NAME= lf-input-stylesheet COMMENT= "input stylesheet for initial load" PHYSICAL-FILE= "+/data/relate.xsl" FORMAT= XML *

0 COMMENTS

We’d like to hear from you!