449 | 07 Dec 2012 @ 10:03 PST | Database | Reply | where does TD store transient journal? | The Filer utility has commands for inspecting the Transient Journal. It is not acually a table. It is a special file system object.
|
448 | 27 Nov 2012 @ 02:27 PST | Database | Reply | How to lock set of tables used by Particular Session (Session Level Integrity) | Teradata, like every other commercial database system, serializes access at the transaction level. If you cannot use transactions to accomplish what you want, you could perhaps implement an e... |
447 | 21 Nov 2012 @ 10:49 PST | Analytics | Reply | Failure 2805 Maximum row length exceeded in table in abc in BTEQ when using SET operator. | It's probably the length of the sort key that pushes the result spool row length over the limit. UNION ALL works because it doesn't require a sort to remove duplicates.
|
446 | 12 Oct 2012 @ 10:34 PDT | Database | Reply | re:RAID AND FALLBACK | Fallback does add overhead and cost. The value is an additional level of protection. If an AMP goes offline for some reason, a fallback-protected table is still accessible. Fallba... |
445 | 04 Oct 2012 @ 11:04 PDT | Cloud Computing | Reply | Certificate errors when trying to start VMserver. | If by "VMserver" you mean the Oracle VM Server, then you are using the wrong product. The Teradata VM is requires a VMWare product, such as VMWare Player.
VMWare Player is ava... |
444 | 10 Aug 2012 @ 11:08 PDT | Database | Reply | RowID versus Identity |
In Teradata, ROWID is not exposed as a column (except when defining a join index) and cannot be used in queries. As far as I know, an identity column is your only option if you require an ... |
443 | 16 Jul 2012 @ 05:53 PDT | Extensibility | Reply | Fast Path UDF -- REGEXP_REPLACE not working with Slashes |
Since "\" is a regular expression metacharacter, you must write "\\" when you want to use it as a literal character.
SELECT REGEXP_REPLACE('standard\addr', '\... |
442 | 20 Jun 2012 @ 05:00 PDT | Tools | Reply | BTEQ - Row Level COMMIT |
create error table for Table_B ;
insert into Table_B select * from Table_A
logging errors ;
This isn't quite what you asked for, as it will automatically continue... |
441 | 01 Jun 2012 @ 02:05 PDT | Database | Reply | aggregation error |
with the_avg(colavg) as (select avg(c)from taba)
select case when colavg <= c then 'less' else 'more' end
from taba, the_avg ;
&n... |
440 | 29 May 2012 @ 04:38 PDT | General | Reply | Insert and Delete in Merge Into |
Consider defining a trigger. I believe triggers are frequently used to capture history for audit purposes.
|
439 | 17 May 2012 @ 12:08 PDT | Database | Reply | Pseudo Table Locking |
No. There is a lock manager component on each AMP that maintains information about locked objects and active lock requests. This information may be displayed using the LOKDISP utilit... |
438 | 11 May 2012 @ 09:41 PDT | Extensibility | Reply | Are User defined Window Aggregates and User Defined Table Functions supported in TD 12.0? |
User-defined table functions and (non-windowed) aggregate functions are supported in 12.0. Window aggregates require 13.10.
|
437 | 09 May 2012 @ 11:17 PDT | Extensibility | Reply | Insert data into database from a UDF |
You can write a table UDF. A table function may be invoked in the FROM clause of a query. Unlike a scalar function, a table function returns a table. See the topic "Table ... |
436 | 09 May 2012 @ 10:57 PDT | Database | Reply | How to handle errors in Merge Into |
Teradata (12.0 and later ) MERGE INTO syntax supports error tables. See the the topic "Logging MERGE Errors In an Error Table" in the SQL Data Manipulation Language volume i... |
435 | 03 May 2012 @ 10:56 PDT | Database | Reply | Can not find alternative of replace function in TD SQL query |
I can't help you with 13.10, but it may interest you to know that 14.0 has implemented OREPLACE and many other Oracle-like functions as built-in functions.
|
434 | 03 May 2012 @ 10:41 PDT | Database | Reply | BTEQ EXPORTING a VALUE to file. |
SELECT (MAX(currentperm)*(HASHAMP()+1))
(FORMAT'--,---,---,---,---,---,--9.99') AS EffUsedSpaceMB ...
Although you say you need 2 decimal place... |
433 | 02 May 2012 @ 11:21 PDT | Database | Reply | Keyword USING while joining the tables |
Teradata doesn't recognize the USING clause in joins. You must use the equivalent ON clause.
|
432 | 23 Apr 2012 @ 11:40 PDT | Cloud Computing | Reply | Is there a workaround to the "... Disabling long mode..." message? |
Check with your laptop vendor's customer support. Unless they have a BIOS update for virtualization support, you are out of luck.
|
431 | 20 Apr 2012 @ 11:34 PDT | Database | Reply | Table size reduced after "ALTER TABLE ADD COLUMN" |
Considering that the difference is less than .2 percent, it may be attributable to a reduction in data block fragmentation.
|
430 | 20 Apr 2012 @ 11:14 PDT | General | Reply | Volatile table issue |
Note that the name of a volatile table is local to the session in which it is created. It is not associated with the name space of any database. Thus the default database setting is ... |
429 | 13 Apr 2012 @ 10:40 PDT | Database | Reply | reset identity column after table move |
If you are using the Archive Utility (restore or copy commands) to move the tables, the identity column next value should be properly set on the destination system. However, there was a pr... |
428 | 06 Apr 2012 @ 10:59 PDT | Database | Reply | Difference between 'Number' and 'Integer' |
INTEGER is a 32-bit binary numeric type. It has a fixed storage size of 4 bytes.
NUMBER is a new data type, introduced in Teradata 14.0, which is intended to emulat... |
427 | 16 Mar 2012 @ 11:10 PDT | Teradata Applications | Reply | TPT 13.0 is compatible with Windows 7?? |
You did not get a good archive. The genuine download should be a zip archive of a VMWare VM image. It does not contain any Windows executables. You run it by opening the *.vmx ... |
426 | 07 Mar 2012 @ 10:21 PST | Database | Reply | Side effects of Identifiers named using ANSI SQL:2008 Reserved Words in code run in ANSI Mode? |
There is no difference in the parsing of key words and identifiers between the Teradata and ANSI session modes. Reserved words are the same in both modes.
|
425 | 01 Mar 2012 @ 03:52 PST | Database | Reply | API for DBC.SysExecSQL |
You can read about it in SQL Stored Procedures and Embedded SQL in the Teradata documentation set. However, you cannot execute a select statement via DBC.SysExecSQL. A dynamic cursor... |