ODBC Connector 24.3

# Create the Sub Table Template File

This section describes how to create the sub-table template file. This template file defines how the information extracted from the `Items` and `Products` table is structured.

When the connector runs the fetch task, this template is combined with the main template and used to generate a single document for each row returned from the main table (`orders`).

To create the sub-table template file

1. In a text editor, create the sub-table template for data extracted from the `Items` and `Products` tables:

       ITEM <!--ProductID-->, <!--ProductName-->, QTY <!--Quantity-->, £<!--Price-->

   Each HTML comment in the sub-table template is replaced by data extracted from the corresponding column (`ProductID`, `ProductName`, and so on) from the joined `Items` and `Products` tables.

2. Save the file as `items.tmpl` in the connector's installation folder (the file name you specified in the configuration file).

Copyright 2024 Open Text
Version 24.3 | Last updated June 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL ODBC Connector 24.3

Topic Title: Create the Sub Table Template File