SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to TeradataMicrosoft Windows XP Professional9.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP4
Microsoft Windows NT Workstation9.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP4
Microsoft Windows 2000 Server9.1 TS1M3 SP4
Microsoft Windows 2000 Professional9.1 TS1M3 SP4
z/OS9.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server9.1 TS1M3 SP4
Microsoft Windows 2000 Advanced Server9.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.