#DateWhereItemComment
409 Mar 2011 @ 04:59 PSTDatabaseWhat you need to know before creating a table in TeradataYou're welcome. I did get confirmation that if there is any UNIQUE INDEX, there will be no duplicate row checking. There is one exception. If the error-logging option is used on an INSERT-SELECT...
308 Mar 2011 @ 05:47 PSTDatabaseWhat you need to know before creating a table in TeradataWith a UNIQUE PRIMARY INDEX, there will be no duplicate row checking (there can't be any duplicate rows if the PIs are unique). With a non-UNIQUE PRIMARY INDEX, but one or more UNIQUE INDEX, dup...
223 Feb 2011 @ 08:30 PSTToolsHow many digits in a DECIMAL?You're welcome. The maximum supported number of decimal digits increased: * From 15 to 18 in V2R2.0 (roughly, 1997). * From 18 to 38 in V2R12.0 (roughly, 2007).
104 Jan 2011 @ 04:39 PSTDatabaseWhat you need to know before creating a table in TeradataOne minor correction: CREATE TABLE will result in a SET table being created if the session is using Teradata semantics; CREATE TABLE will result in a MULTISET table being created if the session is ...