Mapping Fields
You can map the fields listed in the TRN_Fields control group using either offset/length, XPath, or a combination of both methods. In the RunMode control group, be sure to set these INI options:
Option |
Description |
Enter Yes to tell the system you are using the XML file. |
|
Enter Yes to tell the system your extract file contains a list of pointers pointing to the XML file to be processed. |
|
Use this option to tell the system how to find your XML file. Enter the method you use to point to your XML file. This should be exactly the same as how you would set up the rule parameter for the XMLFileExtract rule in your AFGJOB.JDTfile. |
Here is an example:
< RunMode >
XMLExtract = Yes
XMLFileExtract = Yes
XMLFileExtractName = SCH=1,XML 20,60
Also set the TRN_Fields options as shown in this example:
< TRN_Fields >
Company = !/Forms/Key1
PolicyNum = !/Forms/PolicyNum
RunDate = !/Forms/RunDate;DM-4;D4
LOB = 30,15,N
Cust_Name = 46,30,N
The format for the options IN the TRN_Fields control group is:
(Field in the transaction DFD file) = XPath;Field Format
(Field in the transaction DFD file) = offset, length, Key;Field Format
An XML path search must begin with an exclamation mark (!). The exclamation mark is not part of the actual search routine. Do not specify whether a field is a key. The system does not support a multiple (search) keys with the XML implementation.
To selectively exclude transactions, use either an offset/SearchMask, the XPath, or a combination of the two in your exclude file. Here is an example:
!/Forms[PolicyType="OLD"]
20,ABC
© Copyright 2020, Oracle and/or its affiliates. All rights reserved. Legal notices.