ODBC Connector 26.3
ODBC Connector Help

# Create the Sub Table Template File

Create a new template file for the information extracted from the sub table. 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.

To create the sub-table template file

1. In a text editor, create the sub-table template for data extracted from the Customers table:

       Name: <!--Title--> <!--FirstName--> <!--LastName-->
       Address: <!--Address1-->, <!--Town-->, <!--Postcode-->

   When the connector generates documents, each HTML comment in this template is replaced by data extracted from the corresponding column in the Customers sub-table.

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

Copyright 2026 Open Text
Version 26.3 | Last updated July 2026

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 26.3

Topic Title: Create the Sub Table Template File