I am trying to query dbc.columns to find which tables have certain columns and find that dbc.columns is empty. I also find that dbc.tables.referencetext doesn't hold all the table definitions. Is that something that is new in V2R6? If so, how do I find this information?
Silly question - the problem was I headed up my query with what I thought was a comment line - prefaced with --. In fact, although that worked with older versions of SQL assistant/ Teradata, newer versions SQL/*** 7.2.0 and/or Teradata V2R6.1 seem to need comments enclosed within /* */. In this case, SQL Assistant misleads by formatting the line as though it was a comment.