#DateForumTypeThreadPost
1606 Feb 2015 @ 07:39 PSTViewpointReplyAutostats Alert SetupThank Gary   
1529 Jan 2015 @ 02:12 PSTViewpointTopicAutostats Alert SetupHi    We recently upgraded to viewpoint 14.10 and have set up a stats job on viewpoint stats manager however i also wanted to configure an alert to notify the sucess/failure of the stat...
1419 Jan 2015 @ 08:10 PSTDatabaseTopicOnline archive logging cannot be enabledHi  I am getting teh following  warning message while archiving one of our database . I am unable to find out the table for which logging could not be enabled .  01/18/2015 19:40:5...
1317 Dec 2014 @ 09:11 PSTAsterReplyload_from_hcatalog when templeton is not on namenode I tried running the  below query with our new Teradata version 14.10, SQL-H capability to query a Hortonworks Hadoop environment  enabled  and got an error. SELECT  &nbs...
1211 Dec 2014 @ 01:11 PSTDatabaseReplywrite SQL UDF in TeradataHi Tomnolan    I got it.... it was simple,had to increase the precision for day interval to 4 from default 2   Regards Vishnu 
1111 Dec 2014 @ 01:02 PSTDatabaseReplywrite SQL UDF in TeradataHi Tomnolan  I get this error while executing .... select add_days(date,-210) SELECT Failed. 7453:  Interval field overflow.  Can you please let me know how to get rid of th...
1010 Dec 2014 @ 02:29 PSTDatabaseReplywrite SQL UDF in TeradataThat worked like a charm , tomnolan ... Many thanks to you !!!!
910 Dec 2014 @ 10:28 PSTDatabaseReplywrite SQL UDF in TeradataHi  Can  anybody help me write an SQL UDF to add days to a date ?  It simply needs to be accepting a date and a number and adding them together to return another date Please help ...
827 Aug 2014 @ 12:16 PDTGeneralTopicBackup sessions Why backup sessions always show to be  skewed heavily ?is that something to do with the way  backup works  or the backend data distribution is an issue ?   Regards Vishnu Gup...
723 Jul 2014 @ 05:28 PDTTeradata ApplicationsReplyHow to handle failure statement in Bteq ?Hi  I have series of explain DDL statment in a bteq file ,when i run this file ,it errors out after explaining some DDL's  *** Error: reading input, unable to find the end of a r...
621 Jul 2014 @ 07:24 PDTGeneralReplyReplace a String in column Thanks Dieter  That's exactly what i did ,I replaced these strings using "sed" filter and now running an explain to see if it comes out clean however Now  there's is ju...
520 Jul 2014 @ 08:00 PDTGeneralReplyReplace a String in column Hi  I am on 13.10.05.04, While I had no issue doing this .  sel oreplace(requesttext,';;',';') from Mydatabase.temp_table;  but somehow this does not work.......
418 Jul 2014 @ 04:15 PDTGeneralTopicReplace a String in column Hi  I have a a huge task to re-write all the views on the databases  to "Locking row for access" ,I have been working all this week to get a script for this puproose ,I have be...
320 Mar 2014 @ 12:14 PDTGeneralReply list all TASM delayed queries for a user over a specific time periodPerfect Andy , Thank you very much !!!!  
214 Mar 2014 @ 02:14 PDTGeneralTopic list all TASM delayed queries for a user over a specific time periodHi is there a way to list all TASM delayed queries for a user over a specific time frame? Rewind seems to be a difficult choice here as it gives me the information at a particular moment and not ...
109 Feb 2014 @ 02:30 PSTToolsReplyBTEQ exampleshi I have a run file that has collect stats statement for hundred's of databases ,i want that when i execute the run file ,with .run command ,any tables on which stats collection could not be ...