# | Date | Forum | Type | Thread | Post |
10 | 19 Sep 2014 @ 02:41 PDT | Tools | Topic | Teradata Decision Experts (TDE) | Can anyone help me some documentation on Teradata Decision Experts (TDE)?
Mani
|
9 | 19 Sep 2014 @ 02:38 PDT | Database | Reply | No room available in Database testdb. | Hi Parth
Please do the following:
- Take a list of unwanted objects and remove it.
- Do an analysis on space allocation, availability and in each database.
- Decide what is the space requi... |
8 | 18 Sep 2014 @ 10:49 PDT | Database | Reply | New Features in TD V15 | Thank you very much for your response. When I know more, my curiosity forcing me to ask a couple of questions more.
Which are the new licenced features. I have seen that the Teradata Columner is a... |
7 | 17 Sep 2014 @ 11:58 PDT | Database | Topic | New Features in TD V15 | Could you please let me know what are the new features in Teradata V15.
Is there any comparision metrix available with Teradata 14 and 15?
Thanks,
Mani
|
6 | 24 Mar 2013 @ 10:01 PDT | Database | Reply | Will volatile tables be dropped? | Hi Dieter,
Thank you very much for the information.
I have created the Volitile Tables first and then created the Stored Procedure.
Now it gives warnings saying
SPL5000:W(L46), E(3803):Table &... |
5 | 22 Mar 2013 @ 12:10 PDT | Database | Reply | Will volatile tables be dropped? |
Hi Dieter,
When I am trying to create a Volatile Table in the Procedure, it gives an error as below:
SPL1027:E(L71), Missing/Invalid SQL statement... |
4 | 30 Jan 2012 @ 05:36 PST | Database | Reply | SELECT TOP N - odd behaviour (v2r6) |
Hi Dieter,
I do face the same problem when run a select on a Big Table with "TOP" clause.
The explain says "2) Next, we do an all-AMPs STAT FUNCTION step from ...."
... |
3 | 29 Jun 2011 @ 07:55 PDT | Database | Reply | 7547: Target row updated by multiple source rows | No. It does not have any kind of PK/FK relationship.. |
2 | 29 Jun 2011 @ 05:15 PDT | Database | Reply | Table Size issue | In a 25K rows scenario, if the datatype is VARCHAR, the compression cannot be done on that coulumn. There is a Primary Index with uncompressable datatype with large character wide also will narrow... |
1 | 29 Jun 2011 @ 01:07 PDT | Database | Topic | 7547: Target row updated by multiple source rows | Hi,
I am getting an error while doing this update.
UPDATE TGT
FROM TestDB.Table1 TGT,
TestDB.Table2 STG
SET
COL1 = STG.COL1
COL2 = STG.COL2
COL3 = STG.COL3
COL4 = STG.CO... |
|
|