When you are using SQL pass-through with SAS/ACCESS® Interface to Teradata with the CONNECTION=GLOBAL parameter specified, the following error might occur:

The problem, which occurs even when the table does exist in the Teradata database, occurs when a LIBNAME statement that was executed previously points to a different database in Teradata and also uses the CONNECTION=GLOBAL parameter. The SQL pass-through code attempts to connect to that database instead of the database specified in the SQL pass-through code.

To circumvent this issue, do one of the following:

• Remove the CONNECTION=GLOBAL parameter from the SQL pass-through code.
• Clear the LIBNAME statement using the CONNECTION=GLOBAL parameter by using the following statement:

    libname libref clear;

• Add the database name in front of the table name, such as databasename.tablename.