#DateWhereItemComment
617 Jan 2012 @ 04:11 PSTOracleExploring Teradata 13's PERIOD FunctionsEssentially what you're doing with this example is trying to create a PPI using a PERIOD data type even though you're only taking the beginning boundary from it, which cannot be done. To work aroun...
530 Jul 2011 @ 12:01 PDTOracleExploring Teradata 13's PERIOD FunctionsAccording to the Teradata 13.10 SQL Data Types and Literals manual: "A primary index column or partitioning column cannot be a column that has a Period data type." So it isn't possible to create a ...
410 Mar 2011 @ 04:33 PSTDatabaseWhat you need to know before creating a table in TeradataThanks to bwb and dnoeth for their helpful comments. I made a minor clarification to this article about FastLoad or the TPT Load Operator being the utilities that will discard duplicate rows withou...
309 Mar 2011 @ 01:50 PSTDatabaseWhat you need to know before creating a table in TeradataThank you for the question and the answer provided in the comments on duplicate row checking for SET tables. I've updated the article to provide clarification on when duplicate row checking occurs ...
206 Jan 2011 @ 09:18 PSTDatabaseWhat you need to know before creating a table in TeradataYou can tell which semantic mode you're with SQL Assistant or BTEQ using the following information: SQL Assistant (AKA Queryman) - run the HELP SESSION command and look for the column named Transa...
105 Jan 2011 @ 09:43 PSTDatabaseWhat you need to know before creating a table in TeradataThanks for providing the clarification on the effect of the Teradata and ANSI semantics mode on a CREATE TABLE statement when SET or MULTISET aren't specified. I've edited the article to add this c...