28 | 03 Aug 2016 @ 03:23 PDT | Database | Reply | How to find the Object IDs form DBC where it is stored. | Hi Sankalp,
The "next system-generated unique identification number available for use by the system" and that is assigned to object(s) last created can be found in DBC."NEXT... |
27 | 29 Mar 2016 @ 06:06 PDT | Database | Reply | PK used as USI and not UPI | Hi Andy,
Thank you very much for your very valuable input. :)
Best regards,
Win
|
26 | 28 Mar 2016 @ 04:09 PDT | Database | Reply | PK used as USI and not UPI | Hi Carlos,
Thank you for sharing this information.
Best regards,
Win
|
25 | 28 Mar 2016 @ 03:54 PDT | Database | Reply | PK used as USI and not UPI | Thanks, Carlos; but why not implement PK as UPI at first? Why chose a different Primary Index other than the PK in LDM?
Best regards,
Sherwin
|
24 | 28 Mar 2016 @ 02:13 PDT | Database | Reply | PK used as USI and not UPI | Hi Carlos,
Thanks for the response; but why are there instances when a designer is implementing a PK as USI and not as UPI to evenly distribute rows in AMPs.
I am seeing some table defini... |
23 | 28 Mar 2016 @ 01:45 PDT | Database | Reply | PK used as USI and not UPI | Providing added description:
I think that PK as UPI is better since it will uniformly distribute the rows across all AMPs since PK is always unique by definition.
So why use USI for a PK?
|
22 | 28 Mar 2016 @ 01:28 PDT | Database | Topic | PK used as USI and not UPI | What are the reason(s) why a PK will be implemented as USI instead of UPI? This question was formulated based on the following statement:
"Primary keys are implemented as unique secondary ind... |
21 | 23 Mar 2016 @ 06:24 PDT | Database | Reply | Error Dropping a Column in a TRANSACTIONTIME Table | Hi Self :),
This has been resolved. For STEP 6, also use NONTEMPORAL keyword for the ALTER TABLE statement.
Best regards,
Win
|
20 | 23 Mar 2016 @ 06:01 PDT | Database | Topic | Error Dropping a Column in a TRANSACTIONTIME Table | Using Teradata Database 14.0.5 in a Virtual Machine and testing the following steps specified in a reference document, "Temporal Table Support" (Release 14.0) page 36 "Converting Per... |
19 | 05 Feb 2016 @ 03:49 PST | Database | Reply | Spool Space Issue on More Projected Columns Than Lesser Projected Columns | Hi Todd,
Thank you very much for your input.
Best regards,
Win
|
18 | 25 Jan 2016 @ 06:24 PST | Database | Reply | Spool Space Issue on More Projected Columns Than Lesser Projected Columns | I just noticed the the title on my subject is wrong. I cannot edit it; but it should be: "Spool Space Issue on LESSER Projected Columns than on More Projected Columns".
|
17 | 14 Jan 2016 @ 06:26 PST | Database | Reply | Spool Space Issue on More Projected Columns Than Lesser Projected Columns | Hi Rglass,
I think that the statistics are not complete because of the "low confidence" shown in the EXPLAIN of the 2nd query; but I am not the one who is collecting the statistics nor d... |
16 | 11 Jan 2016 @ 03:31 PST | Database | Topic | Spool Space Issue on More Projected Columns Than Lesser Projected Columns | What could be the cause of this?
I have the following two queries with similar source views and joins:
FIRST QUERY
The first one has more columns projected but is not returning a spool space i... |
15 | 27 Nov 2015 @ 03:03 PST | Database | Reply | Where are Stored Procedures stored ? |
Hi Dieter,
After using the "EXPLAIN SHOW PROCEDURE ...", I only received the following information:
1) First, we do an INSERT into Spool 1.
2) Next, we do an IN... |
14 | 29 Sep 2015 @ 02:36 PDT | Database | Reply | Syntax Not Working: "ALTER TABLE <TableName> DROP <ColumnName> CHECK;" | Hi Carlos and Fred,
Thank you for your responses. They have answered my question.
Best regards,
Win
|
13 | 28 Sep 2015 @ 12:49 PDT | Database | Reply | Syntax Not Working: "ALTER TABLE <TableName> DROP <ColumnName> CHECK;" | For the DDL statement after "New Table Definition", please ignore the following:
<em><strong>....</strong></em>)
The correct statement should just be: CHECK ( CO... |
12 | 28 Sep 2015 @ 12:46 PDT | Database | Topic | Syntax Not Working: "ALTER TABLE <TableName> DROP <ColumnName> CHECK;" | The following SQL statement using this syntax failed after query execution:
ALTER TABLE CHILD_TABLE DROP COLUMN1 CHECK;
Is there something missing in this statement? Please note that the follow... |
11 | 16 Sep 2015 @ 10:18 PDT | Database | Reply | SQL Warning 5815 Function is not ANSI | Thanks, Dieter for providing to us the reference.
|
10 | 07 Sep 2015 @ 08:01 PDT | Database | Reply | SQL Warning 5815 Function is not ANSI | Thanks, Dieter. May I know the reference of this information? I just browsed Wikipedia and it was mentioned that CAST is included in SQL-92 ANSI standard. CAST was also mentioned to be included in ... |
9 | 24 Aug 2015 @ 07:00 PDT | Database | Reply | 9334 Invalid constraint definition | Hi Anil,
Temporal Behavior is set to 1 (ANSI Temporal Behavior). Thank you.
|
8 | 24 Aug 2015 @ 04:28 PDT | Database | Topic | SQL Warning 5815 Function is not ANSI | This warning was returned in BTEQ after executing the following query. Is there something missing with the syntax? Please note that the SESSION TRANSACTION was set to ANSI and SESSION SQLFLAG was s... |
7 | 23 Jun 2015 @ 10:35 PDT | Database | Reply | 9334 Invalid constraint definition | I have tried the original query in Teradata Release 15.00.01.08 and the query also worked fine.
So my conclusion is that, the original query that I used works on the latest releases of Teradata 15... |
6 | 21 Jun 2015 @ 05:47 PDT | Database | Reply | 9334 Invalid constraint definition | Hi Dieter,
I am using Teradata 15.00.01.01. Thank you.
|
5 | 20 Jun 2015 @ 03:45 PDT | Database | Topic | 9334 Invalid constraint definition | This error was received after executing the following DDL statement for bitemporal table:
CREATE MULTISET TABLE Policy,
NO FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = ... |
4 | 21 Sep 2014 @ 07:43 PDT | Tools | Reply | TTU 15 Installed, SQL Assistant Error | Hi,
I am also having this exact same error using also the same OS and I think that the version of the OS has nothing to do with it. A friend of mine did not have any issues connecting to the ... |