#DateForumTypeThreadPost
24912 Feb 2010 @ 03:00 PSTDatabaseReplyWhere Clause with CASE WHEN THEN END statement.In a CASE expresssion, THEN must be followed by a scalar value expression. The entire CASE expression evaluates to a scalar value, not a predicate. You can use CASE in a WHERE clause, but the out...
24812 Feb 2010 @ 02:31 PSTDatabaseReplyMLOAD / FLOADJust submit the same script again. MLOAD will automatically resume from the point it where it left off.
24712 Feb 2010 @ 02:28 PSTDatabaseReplycan we assign variable to select statementThe assignment source in a SET statement cannot be a query. I believe you need to write something like this:select count(*) into n2 from retail.emp;
24601 Feb 2010 @ 02:28 PSTToolsReplyRegarding Temporary SpaceThat's not completely correct.Volatile tables use spool space. Global temporary tables use temporary space. The quota of temporary space available to a user is separate from perm space and spool ...
24521 Jan 2010 @ 03:53 PSTDatabaseReplyMERGE INTOThe full ANSI/ISO SQL standard MERGE statement was not supported until Teradata version 12.0.
24420 Jan 2010 @ 01:44 PSTDatabaseReplyMERGE INTOWhich Teradata version are you using? When I tried your SQL on my version 13.0 system, I got a syntax error, " Failure 3810 Column/Parameter 'JBC.t1.t1' does not exist."It seems the Teradata synta...
24305 Jan 2010 @ 02:26 PSTDatabaseReplyConvert Volatile Table to Permanent TableThe correct syntax is:Create Table permtable AS volatiletable with Data ;
24218 Dec 2009 @ 08:22 PSTDatabaseReplyTrigger calling procedureBy definition a trigger executes within the transaction that causes it to be invoked. To shift the workload to another session, consider using a queue table. The trigger would just insert a row i...
24104 Dec 2009 @ 01:49 PSTDatabaseReplyFailure 3610: Teradata Crashes. Do not resubmit the last requestIf you have a critical production issue, you should contact you Terdadata suppport representative immediately. Your company is paying for Teradata support, so why not use it?
24016 Nov 2009 @ 02:08 PSTConnectivityReplyhow to install teradata express edition on windows 7If your Windows machine has an Intel CPU that supports virtualization (Intel VT feature), I recommend the new Teradata Express for VMWare, which you can download from this site. Use it with VMWare...
23906 Nov 2009 @ 05:46 PSTToolsReplyCan I rollback in ANSI mode without Transient Journel?Both Teradata and ANSI session modes use the transient journal. Both modes support transactions that may be rolled back or committed explicitly. In Teradata mode, you can use a BEGIN TRANSACTION ...
23825 Sep 2009 @ 04:59 PDTDatabaseReplyTDE12 on Win 2003 - Connection Reset by PeerYou may be running into the infamous Windows DEP feature. Check out this URL for a detailed explanation of DEP:http://support.microsoft.com/kb/875352In order to run Teradata, you will need to disa...
23724 Sep 2009 @ 06:44 PDTDatabaseReplyTDE12 on Win 2003 - Connection Reset by PeerStart the Windows Event Viewer. When the Teradata DBS restarted, an error event with some diagnostic information should have been recorded in the application event log.
23625 Aug 2009 @ 11:47 PDTDatabaseReplyunion, minus, intersectYou might try asking a more specific question.
23520 Aug 2009 @ 01:23 PDTDatabaseReplyJournalling in TDJournal records are created and buffered (but not necessarily written to disk) before the data block is modified.>> Doubts>> 1)Journalling done on row by row basis or block?It may be ei...
23406 Aug 2009 @ 05:19 PDTDatabaseReplyGlobal Temporary Tables and Secondary IndexThe index is part of, and inseparable from, the materialized instance of the global temporary table. The space it uses is charged against the user's temporary space.
23322 Jul 2009 @ 11:42 PDTToolsReplyhow does fastload identify duplicates while loading ???There's no particular trick to it. Fastload sorts the table after loading it, and the scan for duplicates is an integral function of Teradata's internal sort utility. The method used to remove du...
23210 Jul 2009 @ 06:04 PDTDatabaseReplySpool Space ErrorMake sure you specify a suitable primary index in the volatile table definition to insure that your table is evenly distributed over the AMPs. The spool quota is enforced on each AMP. If too many...
23109 Jul 2009 @ 01:43 PDTDatabaseReplyPPI DisadvantagesThe first case (all columns referenced in the partitioning expression are part of UPI) is allowed. Teradata can enforce the uniqueness constraint efficiently. It only needs to check other rows in...
23008 Jul 2009 @ 01:42 PDTDatabaseReplyPPI Disadvantages1) Why query access slows down if partitioning column is not used in constraint(equality/non-equality).Answer: Because, in the absence of a constraint on the partioning column, all the partitions m...
22902 Jul 2009 @ 12:02 PDTDatabaseReplySET with UPIIf a table has any unique index (primary or secondary) there is never any duplicate row checking. Checking for duplicate rows would be redundant in that case, so the Teradata software recognizes ...
22826 Jun 2009 @ 01:08 PDTDatabaseReplySELECT as a field into an INSERTANSI/ISO (and Teradata) SQL syntax rules require parentheses around the scalar subquery:INSERT INTO TABLE1 (ID, FIELD1,FIELD2)VALUES( (SELECT MAX(ID) + 1 FROM TABLE2), 'Name', '001');This will work...
22726 Jun 2009 @ 12:32 PDTConnectivityReplyTeradata database size-- size of a specific database ?select sum(CurrentPerm) from DBC.DiskSpace where DatabaseName = 'mydbname';
22622 Jun 2009 @ 01:48 PDTDatabaseReplyPuma -pThe puma "-p" option simply enumerates the vprocs in the system. The other columns in the display are generally not useful except perhaps to PDE developers.
22519 Jun 2009 @ 11:50 PDTDatabaseReplyTD12 Major ChangesEvery major release has a long list of major enhancements. You can read about it in the Release Summary, which you can download from this site.

Pages