# | Date | Where | Item | Comment |
---|---|---|---|---|
6 | 17 Jan 2012 @ 04:11 PST | Oracle | Exploring Teradata 13's PERIOD Functions | Essentially 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... |
5 | 30 Jul 2011 @ 12:01 PDT | Oracle | Exploring Teradata 13's PERIOD Functions | According 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 ... |
4 | 10 Mar 2011 @ 04:33 PST | Database | What you need to know before creating a table in Teradata | Thanks 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... |
3 | 09 Mar 2011 @ 01:50 PST | Database | What you need to know before creating a table in Teradata | Thank 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 ... |
2 | 06 Jan 2011 @ 09:18 PST | Database | What you need to know before creating a table in Teradata | You 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... |
1 | 05 Jan 2011 @ 09:43 PST | Database | What you need to know before creating a table in Teradata | Thanks 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... |