#DateForumTypeThreadPost
44907 Dec 2012 @ 10:03 PSTDatabaseReplywhere 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.  
44827 Nov 2012 @ 02:27 PSTDatabaseReplyHow 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...
44721 Nov 2012 @ 10:49 PSTAnalyticsReplyFailure 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.  
44612 Oct 2012 @ 10:34 PDTDatabaseReplyre:RAID AND FALLBACKFallback 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...
44504 Oct 2012 @ 11:04 PDTCloud ComputingReplyCertificate 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...
44410 Aug 2012 @ 11:08 PDTDatabaseReplyRowID 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 ...
44316 Jul 2012 @ 05:53 PDTExtensibilityReplyFast 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', '\...
44220 Jun 2012 @ 05:00 PDTToolsReplyBTEQ - 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...
44101 Jun 2012 @ 02:05 PDTDatabaseReplyaggregation 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...
44029 May 2012 @ 04:38 PDTGeneralReplyInsert and Delete in Merge Into Consider defining a trigger.  I believe triggers are frequently used to capture history for audit purposes.
43917 May 2012 @ 12:08 PDTDatabaseReplyPseudo 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...
43811 May 2012 @ 09:41 PDTExtensibilityReplyAre 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.
43709 May 2012 @ 11:17 PDTExtensibilityReplyInsert 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 ...
43609 May 2012 @ 10:57 PDTDatabaseReplyHow 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...
43503 May 2012 @ 10:56 PDTDatabaseReplyCan 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.  
43403 May 2012 @ 10:41 PDTDatabaseReplyBTEQ EXPORTING a VALUE to file. SELECT (MAX(currentperm)*(HASHAMP()+1))        (FORMAT'--,---,---,---,---,---,--9.99') AS EffUsedSpaceMB ... Although you say you need 2 decimal place...
43302 May 2012 @ 11:21 PDTDatabaseReplyKeyword USING while joining the tables Teradata doesn't recognize the USING clause in joins.  You must use the equivalent ON clause.
43223 Apr 2012 @ 11:40 PDTCloud ComputingReplyIs 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.
43120 Apr 2012 @ 11:34 PDTDatabaseReplyTable 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. 
43020 Apr 2012 @ 11:14 PDTGeneralReplyVolatile 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 ...
42913 Apr 2012 @ 10:40 PDTDatabaseReplyreset 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...
42806 Apr 2012 @ 10:59 PDTDatabaseReplyDifference 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...
42716 Mar 2012 @ 11:10 PDTTeradata ApplicationsReplyTPT 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 ...
42607 Mar 2012 @ 10:21 PSTDatabaseReplySide 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. 
42501 Mar 2012 @ 03:52 PSTDatabaseReplyAPI 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...

Pages