16.10 - Informix Not Available - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K

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 Teradata Database to Informix.