SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 11817: ERROR: At least one of the columns in this DBMS has a datatype that is not supported by this engine

DetailsHotfixAboutRate It
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:

http://www.sas.com/techsup/download/hotfix/b9_sbcs_prod_list.html#011817

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/b9_dbcs_prod_list.html#011817


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to Informix64-bit Enabled AIX9.1 TS1M09.1 TS1M2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.