11 | 19 Jul 2016 @ 02:44 PDT | Database | Reply | Using Volatile table in stored procedure | Hi,
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... |
10 | 11 May 2016 @ 02:26 PDT | Database | Reply | Spool space issue | Thanks for the suggestion. I was able to execute the recursion after removing the duplicates on the joining columns.
|
9 | 10 May 2016 @ 12:21 PDT | Database | Topic | Spool space issue | Hi,
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... |
8 | 26 Apr 2016 @ 02:02 PDT | Database | Topic | Improving 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... |
7 | 10 Apr 2016 @ 11:28 PDT | Database | Reply | Will increasing block size help handle the error : The maximum possible Row length in the table is too large | We 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... |
6 | 08 Apr 2016 @ 03:20 PDT | Database | Topic | Will increasing block size help handle the error : The maximum possible Row length in the table is too large | Hi,
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... |
5 | 11 Feb 2016 @ 10:14 PST | Database | Reply | Teradata SQL Assistant going to Not responding state while querying a table | Where can I see the SQLA error log ?
|
4 | 09 Feb 2016 @ 11:12 PST | Database | Reply | Teradata SQL Assistant going to Not responding state while querying a table | SQLA version is 13.11
TD database version is 14.10
I tried with Sample 10 , still its going to Not responding state .
|
3 | 07 Feb 2016 @ 10:48 PST | Database | Reply | Teradata SQL Assistant going to Not responding state while querying a table | Please help on this issue .
|
2 | 04 Feb 2016 @ 11:03 PST | Database | Topic | Teradata SQL Assistant going to Not responding state while querying a table | Hi,
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 ,... |
1 | 08 Oct 2015 @ 11:07 PDT | Tools | Topic | Installing Teradata Administrator | Hi,
Can anyone please provide some pointers for downloading and installing Teradata Administrator in my system.
Thanks,
Meenakshi
|