 |
 |
Archives of the TeradataForum
Message Posted: Mon, 30 Dec 2002 @ 20:37:27 GMT
| Subj: | | Re: Different results with different default database. |
| |
| From: | | Dieter N�th |
Jim Downey wrote:
| | Does the following sound as if things are working ... : | |
| | We have a query that reads data from DBC.Databases and DBC.Tables and compares it with another table we build that captures catalog
history. We recently noticed that we received different results depending upon who ran the query and from what machine. We were able to
isolate the root cause to be the choice of the default database specified on the ODBC driver. If no default database or our metadata
database is specified, then the query completes successfully. If another database is specified then the query returns fewer rows than
expected. The rows seem related to but not limited to that which is specified as the default database. | |
Sounds familiar to me, had the same problem...
| | FROM DBC.COLUMNS
WHERE (DatabaseName, TableName) IN (
SELECT Database, TableName | |
There it is: You just used Database instead of Databasename ;-)
Dieter
| |
