Problem Note 7212: INFORMIX table names cannot be longer than 18 characters when using
the LIBNAME Access method
SAS/ACCESS Interface to Informix supports table and column names only
up to 18 characters when using the LIBNAME Access method. You can
query tables and columns names longer than 18 characters using
PROC SQL Passthrough.
The maximum length for table and column names supported by the LIBNAME
access method has been increased to 32 characters in SAS 9.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007212
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Informix | HP-UX | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8 TS M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8 TS M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Informix
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2004-02-05 16:06:03 |
| Date Created: | 2002-03-28 12:54:35 |
