17.10 - Informix Not Available - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

Problem: Tables in Informix cannot be selected.

Solution: The Informix OLE DB provider does not support quoted table names even though it indicates to the Teradata Access Module for OLE DB that it must use quotes. Consequently, data can be loaded from Informix only if the Command option is selected and the table name is entered without quotes. The Command option is not available for FastExport, so data cannot be exported from a database to Informix.