#DateForumTypeThreadPost
611 May 2016 @ 12:20 PDTGeneralTopicto remove duplicatesDear Friends, I have a table with username, dbname, objecttablename, object type (Table or view). For some data, there are objecttablename that  is same for both table and view. i.e the view ...
507 May 2016 @ 09:40 PDTDatabaseReplyQuery :: Find tables which are accessed by usersThank you all.
406 May 2016 @ 03:34 PDTDatabaseReplyQuery :: Find tables which are accessed by usersthanks Dieter and Yuva for the help. I have joined the both tables. But, for the object type DB, I am getting NULL as object tablename, columnname though the query text is for e.g. sel * from dbnam...
305 May 2016 @ 08:59 PDTTeradata ApplicationsTopicTPT 15.00.00Hi, I am using TTU 15.00.00 and tried to export a teradata table into a FLAT FILE. I had no issues for some tables. But, I had the below error while extracting the data to a delimited fl...
205 May 2016 @ 08:29 PDTDatabaseTopicQuery :: Find tables which are accessed by userswe are trying to find out the list of all tables being accessed by each user during DDL DML statements. we have access to PDCR. I understand that we can query dbc.tablesv to find all table names i...
119 Apr 2016 @ 12:08 PDTToolsTopicTPT script generator and PDCR query to find AJIHi Friends, I am new to this forum. I hav 2 queries. Kindly request your help. 1) Could any one of you let me know how to generate a TPT script based on parameters. My requirement is to offload ...