Problem Note 3025: V8 SAS/ACCESS to ODBC will not write dataset to v6 library when the odbc
dbms contains character fields longer than 200
When using SAS/ACCESS Interface to ODBC, with the PROC SQL Pass-through
facility, to create/store a SAS dataset in a Version 6 library (library
containing primarily V6 files or a library created using the V6 libname
engine), you may receive the following error:
The variable varname has too long a value for the SASEB engine.
This error will occur if the source, ODBC data file, contains character
fields which are longer than 200 characters. We should accept these
fields and truncate them to 200 characters which is a V6 requirement,
however we are issuing the above error. In the SAS System Release 6.12,
the same code would successfully create the V6 dataset, but truncate the
long value to 200.
Currently, the only circumvent for this problem is to reduce the length
of the character fields which appear in the ODBC source file.
A Defect has been entered for this.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to ODBC | Solaris | 8 TS M0 | |
| Microsoft Windows 2000 Professional | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows 95/98 | 8 TS M0 | 8.2 TS2M0 |
| Microsoft Windows NT Workstation | 8 TS M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8 TS M0 | |
| HP-UX | 8 TS M0 | |
| 64-bit Enabled HP-UX | 8 TS M0 | |
| IRIX | 8 TS M0 | |
| ABI+ for Intel Architecture | 8 TS M0 | |
| 64-bit Enabled AIX | 8 TS M0 | |
| AIX | 8 TS M0 | |
| Tru64 UNIX | 8 TS M0 | |
*
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: | medium |
| Topic: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2003-10-30 12:52:32 |
| Date Created: | 2000-07-12 13:36:33 |
