Problem Note 20515: An error occurs when you attempt to access a Teradata TTU 8.2 library via SAS/ACCESS® Interface to Teradata 9.1.3 Service Pack 4
The following error messages occur when you issue a LIBNAME statement to SAS/ACCESS Interface to Teradata 9.1.3 Service Pack 4 to access a Teradata database when the Teradata TTU 8.2 client is installed.
ERROR: Default database could not be determined. Reissue your statement with the DATABASE= option.
ERROR: Error in the LIBNAME statement.
These error messages are produced when you issue a LIBNAME statement such as the following example:
libname mafstdat teradata server=server-name
schema=schema-name user=tduser password=password;
The SAS/ACCESS Interface to Teradata 9.1.3 Service Pack 4 LIBNAME statement issues a "help session" request, which causes the Teradata client to build an OPTIONS parcel for sending to the database.
The parcel that is generated by the Teradata client has non-zero values for fields that the database expects to be zeros.
SAS has no control over the parcels that are built by the Teradata client.
This issue is planned to be resolved in an upcoming SAS release.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Teradata | Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |
z/OS | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |
*
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: | Data Management ==> Data Sources ==> External Databases ==> Teradata SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2008-03-03 10:31:55 |
Date Created: | 2007-07-05 08:12:06 |