ODBC Connector 25.2
ODBC Connector Help

# 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 2025 Open Text
Version 25.2 | Last updated April 2025

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: Knowledge Discovery ODBC Connector 25.2

Topic Title: Create the Sub Table Template File