#DateForumTypeThreadPost
1309 Aug 2016 @ 02:35 PDTDatabaseReplyUser's DDLThank you all for your answers. Unfortunatly, in my company we can't use the "Teradata studio", but I can obtain all the informations I need from DBC.logonrules, DBC.users and using ...
1205 Aug 2016 @ 06:24 PDTDatabaseTopicUser's DDLHello everybody, Do you know if there is a way to know the DDL of an existing user? In addition, I need to know if a user has the logon privilege or not, but I can't find how can do it. &nbs...
1124 Jul 2014 @ 08:37 PDTDatabaseReplyerror in UPDATE statementHello Dieter, You are right, I'm using TD12. I also tried to use this query:   update DB_UTILS.T_TABLE_C_SIZE t1 from  ( select databasename, tablename, sum(currentperm)...
1024 Jul 2014 @ 08:18 PDTDatabaseTopicerror in UPDATE statementHello, can someone tell me whats wrong in this query?   update DB_UTILS.T_TABLE_C_SIZE a set a.TABLE_SIZE = (  select sum(b.currentperm) from tablesize b where b.databas...
915 May 2014 @ 06:05 PDTToolsReplySet columns width in BTEQTnx Fred ! :-)
813 May 2014 @ 07:02 PDTToolsTopicSet columns width in BTEQHello all, do You know , if is possible to set the columns width in a BTEQ session ( version 13.10 for linux ) ? I mean only the width of some columns of the same type, and not the width of the e...
714 Mar 2014 @ 04:38 PDTToolsReplyTeradata WalletThe solution is to use the escape char (\) before the command $tdwallet, so this is my script   #!/bin/bash [...] bteq  <<EOF .logon 11.51.71.141/US_FND_SSF_DE...
613 Mar 2014 @ 04:19 PDTToolsReplyTeradata WalletI change my script in    #!/bin/bash [...] bteq  <<EOF .logon 11.51.71.141/US_FND_SSF_DEV,$tdwallet(PWD_SSF_DEV); [...] .quit EOF   .....
511 Mar 2014 @ 05:05 PDTToolsTopicTeradata WalletHello! I'm trying to use teradata wallet for encrypt user password on some script. I have insert an item named PWD_SSF_DEV and then I've crete the script deptquery.txt. T...
407 Mar 2014 @ 03:38 PSTViewpointReplySession expiration timeTnx gryback, but it's not my choise ... I must follow the directives of my company ( unfortunately )
305 Mar 2014 @ 01:07 PSTViewpointReplySession expiration timeOn Teradata Viewpoint V14.00.00.03-b40 , I can't see "viewpoint config" in the Admin menu, the sub-menu are only: Alert setup Backup LDAP Servers Managed Servers Portlet...
217 Feb 2014 @ 01:01 PSTViewpointReplySession expiration timeHello Adeel, for stopping the portal, I use viewpoint stop and for start it viewpoint start  
111 Feb 2014 @ 12:47 PSTViewpointTopicSession expiration timeHello. I need to set my viewpoint session never timeout. In the "Teradata Viewpoint Configuration Guide" i find this metod: 1>Stop the Teradata Viewpoint portal 2>Open the file...