Teradata

We do not officially support Teradata, as we aren't running a copy of it ourselves. However, we understand that a number of AQT users are successfully running AQT against Teradata.

Some Teradata users have noted that the following has to be done in order for AQT to work:

• when configuring the ODBC configuration for your Teradata database, ensure that the No Help Database option is selected
• one user could not display information because they did not have access to the Teradata system tables. If this is the case you will see an error message at the bottom of the window. To correct, ensure you have access to these tables

Table name ambiguous

Some users have experienced the following message when running a query:

S0002(-3806)[NCR][ODBC Teradata Driver][Teradata RDBMS] Table/view/trigger name 'xxxxxxx' is ambiguous

This can happen if you are using a qualified table-name in your query. For example you might have:

select * from dev1.tableA

The cause of this problem is the Default Database setting in the ODBC Configuration for your database. If this is (for instance) dev2 then Teradata will look at both dev1 and dev2 for a table called tableA. If it is in both, you will get the ambiguous table-name message.

The solution is to change the Default Database to a database that doesn't have a table of that name.