Operations Guide

10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1 HotFix 1
- 10.1
- 10.0 HotFix 1
- 10.0

Back Next

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
*

Rename Saved Search

Table of Contents

Operations Guide

Operations Guide

XML Input

XML Input