Problem Note 11817: ERROR: At least one of the columns in this DBMS has a datatype that is
not supported by this engine
One of the following two error messages may be issued when attempting
to access Informix using SAS/ACCESS Interface to Informix.
ERROR: At least one of the columns in this DBMS table has a datatype
that is not supported by this engine.
ERROR: This DBMS table or view cannot be accessed by the SAS System
because it contains column names that are not unique when a SAS
normalized (uppercased) compare is performed. See "Naming
Conventions" in the SAS/ACCESS documentation.
The images of sasionfx and sasnfx were not built correctly which results
in this problem.
A Technical Support hot fix for SAS 9.1 (TS1M0) for this
issue is available at:
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
Operating System and Release Information
SAS/ACCESS Interface to Informix
64-bit Enabled AIX
64-bit Enabled Solaris
64-bit Enabled HP-UX
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
A fix for SAS 9.1 (9.1 TS1M0) for this issue is available at: