#DateForumTypeThreadPost
1402 Jun 2016 @ 05:07 PDTDatabaseReplyDDL's Compare of 2 tablesI have developed a Stored Procedure which will first Generate DDLS and then will Compare DDL's . For generation i have used Java Code wrapped in JAR. and Calling the Jar  in Loop. It Works.
1321 Apr 2016 @ 08:07 PDTDatabaseTopicPass Table name in from statement by Other meansHi All,   It may seem weird, but i came across this. i have a stored procedure written which takes isource_db as input, Eg: UAT_GCFR_VIEW.XYZ Now Ahead in the Stored Procedure, i need to ex...
1231 Jan 2016 @ 07:27 PSTDatabaseTopicCompare Rights of two DatabaseHi, I am working on building query which will compare "Rights Held by Database1" with "Rights Held by Database2".  Can anyone please suggest what should be the desired qu...
1129 Oct 2015 @ 09:02 PDTGeneralTopicDefault path for UDF on a Linux serverHi All, How can i know Default path for source code on a Linux server like :  /etc/opt/teradata/tdconfig/Teradata/tdbs_udf/usr/   I need to get the path for Deployment of JAR File....
1020 Oct 2015 @ 02:58 PDTDatabaseTopicError: Result Exceeded Maximum Length while selecting TableHi All,   I am selecting a table and while running below query, i am getting this Error: Select Failed 9134 Result Exceeded Maximum Length.   SELect oreplace(a.requesttext,'dev7...
916 Oct 2015 @ 12:32 PDTDatabaseReplyDDL's Compare of 2 tablesHow to compare DDL of Stored Procedure of  2 different Environments? Any Idea?  
815 Oct 2015 @ 10:28 PDTDatabaseTopicComparing Two EnvironmentHi, I need to write a Stored Procedure to compare two Environment's(eg. Dev1_stg with Dev12_stg) Tables, Stored Procedure, UDF, Especially Views. Can any one suggest how can i approach this co...
712 Oct 2015 @ 03:23 PDTDatabaseTopicQuery to find Skew Factor of Tables Having Count >1000 Hi ,   I need to get the skew factor of those tables whose count is greater than 1000. As below query is giving me 5-6 outputs how can i use the output table name in below Query. ...
616 Sep 2015 @ 08:32 PDTDatabaseTopicSettings (DBS Control ) Should be changed for changing TIMEZONE?   Hi Guys, i have come up with a situation where the data comes from different server and now i want to get them all in Common TIMESZONE - i.e AEST (Australia ...
516 Sep 2015 @ 06:33 PDTGeneralTopicWhich DBS Control Settings Should be changed for changing TIMEZONE?Hi Guys, i have come up with a situation where the data comes from different server and now i want to get them all in Common TIMESZONE - i.e AEST (Australia Eastern) , so Help me in Identifying wh...
413 Sep 2015 @ 04:25 PDTDatabaseReplyWhich DBS control settings affect Teradata Performance?Okay Dieter,  Thank You
310 Sep 2015 @ 05:21 PDTDatabaseReplyWhich DBS control settings affect Teradata Performance?One more Dieter, What all Values should be Majorly changed in DBS Control for Development and Production Environment? which may Majorly affect both individually.
210 Sep 2015 @ 05:18 PDTDatabaseReplyWhich DBS control settings affect Teradata Performance?Thanks a lot Dieter,  It helped me alot. Thanks a Ton.    
109 Sep 2015 @ 11:38 PDTDatabaseTopicWhich DBS control settings affect Teradata Performance?Hi all, Can anyone let me know which all settings are needed to be optimized in DBS Control Settings. Can u list down those which are recommended.? i have gone thorugh in Teradata PDF of Utilities...