ODBC Connector 23.3

# Modify the Main Template File

Modify the main template file to include the information extracted from the `Items` and `Products` tables. This example shows how to insert a reference to the sub-table template.

To modify the main template file

1. Open the main template file in a text editor. In this example, the main template file is `template.tmpl`, in the connector's installation folder.

2. Specify the location where data from the sub-tables should be included. To do this, insert an HTML comment (`<!--comment-->`) where `comment` is the name of the section in the configuration file that you specified in the `SubTables` parameter. For example:

       #DREREFERENCE <!--OrderID-->
       #DREFIELD Date="<!--Date-->"
       #DREFIELD CustomerID="<!--CustomerID-->"
       #DREFIELD Status="<!--Status-->"
       #DRECONTENT
       Order information
       Date Received: <!--Date-->
       Status: <!--Status-->

       Customer information
       <!--Customers-->

       Items
       <!--ItemDetails-->
       #DREENDDOC

3. Save and close the main template file.

Copyright 2023 Open Text
Version 23.3 | Last updated June 2023

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 swpdl.idoldocsfeedback@microfocus.com.

We appreciate your feedback!

Product: IDOL ODBC Connector 23.3

Topic Title: Modify the Main Template File