#DateForumTypeThreadPost
2803 Aug 2016 @ 03:23 PDTDatabaseReplyHow 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...
2729 Mar 2016 @ 06:06 PDTDatabaseReplyPK used as USI and not UPIHi Andy,   Thank you very much for your very valuable input. :)   Best regards, Win
2628 Mar 2016 @ 04:09 PDTDatabaseReplyPK used as USI and not UPIHi Carlos,   Thank you for sharing this information.   Best regards, Win
2528 Mar 2016 @ 03:54 PDTDatabaseReplyPK used as USI and not UPIThanks, 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
2428 Mar 2016 @ 02:13 PDTDatabaseReplyPK used as USI and not UPIHi 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...
2328 Mar 2016 @ 01:45 PDTDatabaseReplyPK used as USI and not UPIProviding 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?  
2228 Mar 2016 @ 01:28 PDTDatabaseTopicPK used as USI and not UPIWhat 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...
2123 Mar 2016 @ 06:24 PDTDatabaseReplyError Dropping a Column in a TRANSACTIONTIME TableHi Self :), This has been resolved. For STEP 6, also use  NONTEMPORAL keyword for the ALTER TABLE statement.   Best regards, Win
2023 Mar 2016 @ 06:01 PDTDatabaseTopicError Dropping a Column in a TRANSACTIONTIME TableUsing 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...
1905 Feb 2016 @ 03:49 PSTDatabaseReplySpool Space Issue on More Projected Columns Than Lesser Projected ColumnsHi Todd, Thank you very much for your input.   Best regards, Win
1825 Jan 2016 @ 06:24 PSTDatabaseReplySpool Space Issue on More Projected Columns Than Lesser Projected ColumnsI 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".
1714 Jan 2016 @ 06:26 PSTDatabaseReplySpool Space Issue on More Projected Columns Than Lesser Projected ColumnsHi 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...
1611 Jan 2016 @ 03:31 PSTDatabaseTopicSpool Space Issue on More Projected Columns Than Lesser Projected ColumnsWhat 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...
1527 Nov 2015 @ 03:03 PSTDatabaseReplyWhere 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...
1429 Sep 2015 @ 02:36 PDTDatabaseReplySyntax 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
1328 Sep 2015 @ 12:49 PDTDatabaseReplySyntax 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...
1228 Sep 2015 @ 12:46 PDTDatabaseTopicSyntax 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...
1116 Sep 2015 @ 10:18 PDTDatabaseReplySQL Warning 5815 Function is not ANSIThanks, Dieter for providing to us the reference.
1007 Sep 2015 @ 08:01 PDTDatabaseReplySQL Warning 5815 Function is not ANSIThanks, 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 ...
924 Aug 2015 @ 07:00 PDTDatabaseReply9334 Invalid constraint definitionHi Anil, Temporal Behavior is set to 1 (ANSI Temporal Behavior). Thank you.
824 Aug 2015 @ 04:28 PDTDatabaseTopicSQL Warning 5815 Function is not ANSIThis 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...
723 Jun 2015 @ 10:35 PDTDatabaseReply9334 Invalid constraint definitionI 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...
621 Jun 2015 @ 05:47 PDTDatabaseReply9334 Invalid constraint definitionHi Dieter, I am using Teradata 15.00.01.01. Thank you.
520 Jun 2015 @ 03:45 PDTDatabaseTopic9334 Invalid constraint definitionThis 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 = ...
421 Sep 2014 @ 07:43 PDTToolsReplyTTU 15 Installed, SQL Assistant ErrorHi, 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 ...

Pages