#DateForumTypeThreadPost
42408 Feb 2012 @ 10:58 PSTDatabaseReplyError 3706 while creating TRANSACTIONTIME Temporal Table I believe that temporal support is enabled in the Teradata Express Edition release for 13.10.  Can anyone confirm that?  
42302 Feb 2012 @ 02:55 PSTDatabaseReplycan we execute a macro inside a stored procedure? No. Executing a macro from a stored procedure is not supported.
42226 Jan 2012 @ 04:27 PSTDatabaseReplyCREATE INDEX ACCESS The DROP TABLE access right should be sufficient to create an index.  If a request fails because of an access right violation, the error message should tell you exactly which access right w...
42111 Jan 2012 @ 11:02 PSTGeneralReplyTeradata Versions Naming Convention Actually TD12 was originally going to be called V2R7 before the new versioning scheme was implemented.  The new scheme is based on the reckoning that, although V2R1 was the f...
42006 Jan 2012 @ 10:45 PSTDatabaseReplyTpump Del Issue APPLY is not a TPUMP command; it is an argument of the .IMPORT commmand.  Since your DELETE statement does not reference any variables from an import file, it is not an appropriate appl...
41905 Jan 2012 @ 09:59 PSTDatabaseReplydistribution and access details for fallback amps Ulrich, the fallback row is always in the same cluster as the primary. 
41815 Dec 2011 @ 02:56 PSTCloud ComputingReplyPerformance issue with Teradata Express for VMware Player That query takes 2 seconds on my 13.10 VM, but it is installed on a fast workstation.  Perhaps your host machine is underpowered.
41714 Dec 2011 @ 03:39 PSTDatabaseReplyTeradata Express for Windows - where are database files? Teradata Express for Windows is a special case.  It has a modified file system that is built inside regular Windows files.  I don't know what the files are named, but there wi...
41609 Dec 2011 @ 11:40 PSTCloud ComputingReplyVMWARE - Installing Linux TD VMWARE. I just tried your link, and it is definitely bad.  Try downloading the latest 13.10 version.
41509 Dec 2011 @ 11:24 PSTCloud ComputingReplyVMWARE - Installing Linux TD VMWARE. That doesn't look anything like what you should have gotten.  There should not be any .exe files.  The only object in the ZIP archive should be a directory named something like &qu...
41409 Dec 2011 @ 10:36 PSTCloud ComputingReplyVMWARE - Installing Linux TD VMWARE. What you describe is very strange.  The downloadable should be a zip archive containing a regular VMWare VM image, i.e., including .vmx file.  There should not be any .exe file in...
41308 Dec 2011 @ 04:22 PSTExtensibilityReplyREGEXP_LIKE The EXTERNAL NAME literal string should be 'CS!pattern!c:/try/pattern.c!F!Find_Text'. The initial 'C' indicates that the source is on the client. The 2nd character, '...
41207 Dec 2011 @ 11:52 PSTCloud ComputingReplyNot able to import Teradata express to VMWARE server VMWare has dropped support for VMWare Server.  You may need to use VMWare Player instead.  I am currently running several Teradata VMs on my Windows 7 host with perfect succe...
41107 Dec 2011 @ 11:34 PSTExtensibilityReplyREGEXP_LIKE Even so, I don't see REGEXP_LIKE in the list of implemented functions for 14.0.  We offer REGEXP_SIMILAR, which might be a satisfactory substitute.
41007 Dec 2011 @ 10:32 PSTDatabaseReplyAltering SET to MULTISET The correct answer to "why" in cases like this is often the business requirement was never presented ... or we just didn't think of it at the time.
40928 Nov 2011 @ 11:35 PSTDatabaseReplyAn oddity regarding compression on TD 13 Express VMWare edition The Express Edition is offered on an "as is" basis.  Patches are available only to customers who have purchased one of the regular licensed editions.
40817 Nov 2011 @ 10:29 PSTDatabaseReplyNumeric sizing when using aggregation You can make the cast automatic by defining it in a view.  Then give your users and front-end tools access to the view instead of the base table.
40716 Nov 2011 @ 03:19 PSTDatabaseReplyNumeric sizing when using aggregation If storage efficiency is a concern, define the base table column with the smaller type.  To prevent overflow with the SUM function, you can simply cast the argument to the larger type (INT ...
40615 Nov 2011 @ 03:13 PSTCloud ComputingReplyTD Express on MacBook Pro I am not a MAC user, but I suppose the first thing you need to do is purchase & install VMWare Fusion.  See the VMWare web site for purchase and download info.  Fusion is functiona...
40512 Oct 2011 @ 11:17 PDTDatabaseReplyhow to make Compression Equal?! It is possible to run a backup and restore (or copy) operation in parallel using a named pipe or Unix FIFO as the intermediate archive.  This is a commonly used technique to avoid landing t...
40410 Oct 2011 @ 04:53 PDTGeneralReplyRemoving text and brackets The SUBSTRING function has pecular argument syntax.  This is mandated by the ANSI/ISO SQL standard.  The SUBSTR function, on the other hand, works just like SUBSTRING, but it has ...
40310 Oct 2011 @ 11:50 PDTAnalyticsReplyString Search and Replace. Release 14.0 provides the OREPLACE function as a system function.  It also provides the REGEXP_REPLACE function.
40210 Oct 2011 @ 10:38 PDTDatabaseReplyRegular Expressions? Teradata insiders are not permitted to talk about features of future product versions that have not been officially announced.   Since the content of the upcoming Teradata 14.0 was ann...
40107 Oct 2011 @ 10:28 PDTDatabaseReplyTeradata express no listening on 1025 Teradata listens on whatever port is bound to "tdmst" in the /etc/services file.  By default, this is 1025.
40004 Oct 2011 @ 01:00 PDTThird Party SoftwareReplyTeradata on Linux First, download and install VMWare player.  Then download Teradata Express Edition for VMWare Player.  Just unzip the files to a disk with sufficient free space.  Then run the Ter...

Pages