IBM Content Manager OnDemand, Version 9.5

Defining fields

The first field identifies where ACIF locates the date.

ACIF uses fields to determine where to locate index values. For the sample loan report, define two fields. The second field identifies where ACIF locates the loan number.

The Identifier (Field1) determines the name of the field parameter. The Trigger (Trigger1) determines the name of the trigger parameter that ACIF uses to locate the field. The Records to Search area contains the number of the record where ACIF can find the field, offset from the trigger. For the loan report, the field record and the trigger record are the same. The Columns to Search area determines the column number (83) where ACIF locates the beginning of the field. The Size area determines the length (8) of the field. The Reference String area lists the selected field value.

To define fields:

  1. Select the field by clicking the area in the report that contains the field data. For example, in the sample loan report, select the date value displayed in column 83 of the first record on the page. The date is displayed as 10/01/94 (mm/dd/yy). The graphical indexer highlights the value.
  2. Right-click the field and select Field to display the Add a Field.
  3. Save the field information and click OK to add the field and return to the report window.
  4. Right-click the Transaction field to open the Add a Field dialog box. To support the way that Content Manager OnDemand should segment and load the data and the way users will search for reports, define a transaction field. A transaction field allows Content Manager OnDemand to index a group of pages by using the first index value on the first page and the last index value on the last page. This is an excellent way to segment large reports, which results in proper data loading and better retrieval performance.
  5. Select the field by clicking the area in the report that contains the field data. Select the loan number that is displayed in column three of the ninth record on the page. The loan number is displayed as 0000010000.

Verify the options and data values for the field. The Identifier is Field2. The Order (By Row) identifies how the field data is organized. The Mask determines the pattern of symbols that ACIF matches to data located in the field. The number symbol (#) matches any numeric character. The string of ten number symbols matches a ten-character numeric field. The Size area contains the field length (10). The Column Offsets area determines the location of the field value from the beginning of the record. A transaction field can identify up to eight data values, each located with a Start and End value. For the loan report, the field identifies one value, starting in column three and ending in column twelve.