Usage Note 3265: PROC SQL Passthrough may assign an invalid format width when creating
SAS variables from Informix money or decimal tyes
When PROC SQL passthrough is used to create a SAS data set from an
Informix table that contains money or decimal data types, the default
format assigned to the corresponding SAS variables could have an invalid
length.
In a one particular case, PROC SQL assigned the format "dollar34.", even
though "dollar32." is the maximum width allowed for the dollar format.
While this problem is caused by incorrect information passed from
Informix to SAS, steps will be taken to prevent this problem in the
future.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Informix | 64-bit Enabled AIX | 8 TS M0 | 8.2 TS2M0 |
| AIX | 8 TS M0 | 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: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> Informix
|
| Date Modified: | 2000-09-07 17:26:13 |
| Date Created: | 2000-08-21 16:14:13 |
