Dictionary Views


Dictionary Views

I am executing a sql statement that queries dbc.users. When I log directly into a node and execute the statement I get a result set that is different from when I execute it in sql assistant on my desktop. Assuming I am accessing the same dictionary from both places, shouldn't the result sets be the same? If not, can I get an explanation as to why they may differ?


Re: Dictionary Views

The only two reasons I can think of is

(1) You are logging into two different teradata servers
(2) You are using two different login ids in both cases (dbc.users would display data dependent on the user id that's logged on)