Use this field level rule to take data from an extract record. Next, use the data as a key name to look up the key data in a table. Then, copy the table data to the destination field. You must specify the offset of the key name in the data field, as well as the offset and length of the key data in the data field. This rule uses the same table as the MovTbl rule.
You can use one or more files to keep the tables used by this rule. You must list each table (file) in the TABLEFILE.DAT file. The table list file must be in the following format:
TABLEFILENAME1.EXT <crlf>
TABLEFILENAME2.EXT <crlf>
where each table is listed on a single line followed by a carriage return/line feed.
The format of the tables is key name followed by key data. The key need not be a specific length. The data can also be any length, which allows a single table or group of table files to contain table entries of varying lengths.
You specify the table list file using the TblFile option under the Data control group in the FSISYS.INI file.
For example, suppose a form contains the names and numbers of agents for calling purposes, but these names and numbers change on a regular basis. For this situation you could create a text table called AGENTS.TBL which contains entries such as...
AGENT001 JOE MILLER <crlf>
and another table, called AGENTPHO.TBL, with phone number entries such as...
AGENT001PHONE404 111-2222 <crlf>
You could then make these tables available to Documaker Server by including them in the files specified in the Data control group of the FSISYS.INI file, as shown here:
< Data >
You must load the tables into memory before the system can use them. To do this, include these rules in the AFGJOB.JDT file:
;CreateGlbVar;1;TblLstH,PVOID;
;LoadTblFiles;1;;
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.