#DateForumTypeThreadPost
1614 Oct 2013 @ 02:19 PDTDatabaseReplyExpired Password PromptPlease check if you have more than one TeraGSS and tdicu installed. You need to re-install TTU and try again.
1525 Jul 2013 @ 07:54 PDTDatabaseReplyIs there any automated tool to compress the data in Teradata..We use a SP to generate the Compression Script -- The procedure can apply Multi Value Compression (MVC) up to 15 values. The table that we try to compress needs to have an entry in some metad...
1431 Oct 2012 @ 07:15 PDTDatabaseTopicAlert for certain DDL/DML queries at real time using VP, TASM or any other means?  Hi, Is there a way I can send alerts using VP, TASM or any other means only for collect stats queries? My intension is to set up an alert for long running collect stats during business hou...
1302 Oct 2012 @ 02:07 PDTGeneralReplyTable exists and shows in dbc.tablesize but not showing in dbc.tables      Thanks Dieter, WAQ I just found the issue:  the tables were created by ETL jobs - they created tables with "¸" in the name which is not the comma (&quo...
1201 Oct 2012 @ 01:57 PDTGeneralTopicTable exists and shows in dbc.tablesize but not showing in dbc.tables  I had a scenario where I couldn't find some tables in dbc.tables but could find the same via dbc.tablesize. I was looking for tables with comma ',' added to the table name...
1114 May 2012 @ 07:17 PDTDatabaseReplyTrimming Inner Spaces Or you can create a procedure like this:  you can give the input string that need to be modified and the string that need to be trimmed: REPLACE PROCEDURE  TEST123DJ  ( ...
1004 May 2012 @ 11:27 PDTDatabaseReplyDay Of Week or Week-Ending Function? Try this: sel case when day_of_week=1 then 'Saunday' when day_of_week=2 then 'Monnday' when day_of_week=3 then 'Tuesday' when day_of_week=4 then 'Wedn...
902 May 2012 @ 06:51 PDTDatabaseReplyAvoid prdct join Step 3 shows "no confidence", check if you have stats collected on TABLE2DB.TABLB_STG.SRC_CD column.  Run "diagnostic helpstats on for session;" and c...
830 Apr 2012 @ 11:57 PDTDatabaseReplyTeradata Service not starting Please check if you have a host entry as per the installation instruction, then change the network properties to Bridged:  "The easiest solution is to set the VM network mode ...
703 Apr 2012 @ 02:22 PDTDatabaseReplyNeed Help in creating a copy of the Table structure without any secondary indexes and Partitions I am not using dbc.columns,   I am using dbc.indices... on top of that I have a filter for Primary Index...    You can create the macro and try executing it...
603 Apr 2012 @ 07:53 PDTDatabaseReplyNeed Help in creating a copy of the Table structure without any secondary indexes and Partitions Use the logic applied in this macro:   Replace Macro Test123 ( databasename1 varchar (30), databasename2 varchar (30) ) as ( sel 'Create Table &#...
529 Mar 2012 @ 07:40 PDTDatabaseReplyTransform rows to one column string You can use the below method to change columns to rows:   Select D1.Databasename,D1.username, coalesce(Max(CASE WHEN PosN =0 THEN D1.Accessright END), '') ||' '|...
423 Mar 2012 @ 10:55 PDTDatabaseReplyLogging Users List If you are talking about DBQL: you can get the list of users/accounts from DBQL tables  Try this: SELECT Case WHEN SummaryFlag = 'F' THEN ' Logging WITH ' WH...
314 Nov 2011 @ 09:46 PSTDatabaseReplyCHECKTABLE UTILITY -- ERROR I know its too late to comment for this post. But I am adding my comment for those who look for some help in finding the tables with missing header:      &...
205 Oct 2011 @ 10:05 PDTDatabaseReplyTeradata .Net Dataprovider connection error I know this is an old post. I spent lot of time searching the root cause of this login issue. So I would like to add my comment for those who investigate this issue in future. If the pa...
110 Jun 2011 @ 01:23 PDTToolsReplyTeradata Parallel Transporter Wizard 13.10 IssuesAye you on Windows 7? For which directory you had the issue?