Problem Note 7957: TEXT fields are truncated when using SAS/ACCESS Interface to Informix
with PROC SQL Passthrough
When using PROC SQL Passthrough to Informix, the values for TEXT fields
are being truncated. However, using the LIBNAME access engine, it works
properly. The following NOTE may be issued when truncation occurs with
PROC SQL Passthrough:
NOTE: The data value for column short_descr (short_descr) was truncated
or was out of range 10 times when retrieving that data from the
DBMS.
The Informix engine fails to fetch 'text' data using PROC SQL
Passthrough because SAS fails to get the maximum length of the text
column.
To circumvent this problem, use the LIBNAME access engine instead of
PROC SQL Passthrough.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007957
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Informix | Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 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: | 2002-07-16 12:43:36 |
| Date Created: | 2002-07-10 15:27:22 |