#DateForumTypeThreadPost
1119 Jul 2016 @ 02:44 PDTDatabaseReplyUsing Volatile table in stored procedureHi, Even I need help on this topic. I have to create multiple volatile tables inside a stored procedure and use them for returing output to user in the form of cursor. But I am unable to compile t...
1011 May 2016 @ 02:26 PDTDatabaseReplySpool space issueThanks for the suggestion. I was able to execute the recursion after removing the duplicates on the joining columns.
910 May 2016 @ 12:21 PDTDatabaseTopicSpool space issueHi,  Please help me to tune the below query . Its failing with Spool space issue . WITH     RECURSIVE HIER (  RELATION_ID ,TO_ID ,FROM_ID ,LVL )&nbs...
826 Apr 2016 @ 02:02 PDTDatabaseTopicImproving performance of non PI - non PI join Hi, How do I improve performace of a query which has non PI joins ? There are some tables which are getting joined on non PI columns and hence, lot of redistribution is happening , hence leading t...
710 Apr 2016 @ 11:28 PDTDatabaseReplyWill increasing block size help handle the error : The maximum possible Row length in the table is too largeWe had reviewed the column lengths to consider the size really needed for our data , still it is exceeding the row length limit and throwing error 3933 . Is there some other way other than splittin...
608 Apr 2016 @ 03:20 PDTDatabaseTopicWill increasing block size help handle the error : The maximum possible Row length in the table is too largeHi, I am getting error 3933 : The Maximum possible Row length in the table is too large . The table contains around 800 columns that is being pulled from Greenplum as source . Will increasing the...
511 Feb 2016 @ 10:14 PSTDatabaseReplyTeradata SQL Assistant going to Not responding state while querying a tableWhere can I see the SQLA error log ?
409 Feb 2016 @ 11:12 PSTDatabaseReplyTeradata SQL Assistant going to Not responding state while querying a tableSQLA version is 13.11 TD database version is 14.10 I tried with Sample 10 , still its going to Not responding state .
307 Feb 2016 @ 10:48 PSTDatabaseReplyTeradata SQL Assistant going to Not responding state while querying a tablePlease help on this issue .
204 Feb 2016 @ 11:03 PSTDatabaseTopicTeradata SQL Assistant going to Not responding state while querying a tableHi, When I am querying a particular table, Teradata SQL assistant is going to not responding state . Table record count is 19K Table structure : CREATE SET TABLE <TABLENAME> ,NO FALLBACK ,...
108 Oct 2015 @ 11:07 PDTToolsTopicInstalling Teradata AdministratorHi, Can anyone please provide some pointers for downloading and installing Teradata Administrator in my system.  Thanks, Meenakshi