424 | 08 Feb 2012 @ 10:58 PST | Database | Reply | Error 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?
|
423 | 02 Feb 2012 @ 02:55 PST | Database | Reply | can we execute a macro inside a stored procedure? |
No. Executing a macro from a stored procedure is not supported.
|
422 | 26 Jan 2012 @ 04:27 PST | Database | Reply | CREATE 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... |
421 | 11 Jan 2012 @ 11:02 PST | General | Reply | Teradata 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... |
420 | 06 Jan 2012 @ 10:45 PST | Database | Reply | Tpump 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... |
419 | 05 Jan 2012 @ 09:59 PST | Database | Reply | distribution and access details for fallback amps |
Ulrich, the fallback row is always in the same cluster as the primary.
|
418 | 15 Dec 2011 @ 02:56 PST | Cloud Computing | Reply | Performance 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.
|
417 | 14 Dec 2011 @ 03:39 PST | Database | Reply | Teradata 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... |
416 | 09 Dec 2011 @ 11:40 PST | Cloud Computing | Reply | VMWARE - Installing Linux TD VMWARE. |
I just tried your link, and it is definitely bad. Try downloading the latest 13.10 version.
|
415 | 09 Dec 2011 @ 11:24 PST | Cloud Computing | Reply | VMWARE - 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... |
414 | 09 Dec 2011 @ 10:36 PST | Cloud Computing | Reply | VMWARE - 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... |
413 | 08 Dec 2011 @ 04:22 PST | Extensibility | Reply | REGEXP_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, '... |
412 | 07 Dec 2011 @ 11:52 PST | Cloud Computing | Reply | Not 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... |
411 | 07 Dec 2011 @ 11:34 PST | Extensibility | Reply | REGEXP_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.
|
410 | 07 Dec 2011 @ 10:32 PST | Database | Reply | Altering 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.
|
409 | 28 Nov 2011 @ 11:35 PST | Database | Reply | An 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.
|
408 | 17 Nov 2011 @ 10:29 PST | Database | Reply | Numeric 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.
|
407 | 16 Nov 2011 @ 03:19 PST | Database | Reply | Numeric 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 ... |
406 | 15 Nov 2011 @ 03:13 PST | Cloud Computing | Reply | TD 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... |
405 | 12 Oct 2011 @ 11:17 PDT | Database | Reply | how 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... |
404 | 10 Oct 2011 @ 04:53 PDT | General | Reply | Removing 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 ... |
403 | 10 Oct 2011 @ 11:50 PDT | Analytics | Reply | String Search and Replace. |
Release 14.0 provides the OREPLACE function as a system function. It also provides the REGEXP_REPLACE function.
|
402 | 10 Oct 2011 @ 10:38 PDT | Database | Reply | Regular 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... |
401 | 07 Oct 2011 @ 10:28 PDT | Database | Reply | Teradata express no listening on 1025 |
Teradata listens on whatever port is bound to "tdmst" in the /etc/services file. By default, this is 1025.
|
400 | 04 Oct 2011 @ 01:00 PDT | Third Party Software | Reply | Teradata 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... |