#DateForumTypeThreadPost
29905 Aug 2010 @ 10:14 PDTDatabaseReplySeek clarification for Reserved words Karam, At least some of the words you cited as reserved are not classified as reserved. They are classified as "nonreserved keywords" by Teradata and/or the ANSI/ISO SQL standard, which means t...
29805 Aug 2010 @ 09:59 PDTDatabaseReplyhow teradata identify for the psuedo tableThe "pseudo table" is simply a hash derived from the real table's ID. Its purpose is to prevent false deadlocks. Before we implemented this technique, two transactions that contended for a lock o...
29704 Aug 2010 @ 09:01 PDTDatabaseReplyFallbackYou are essentially correct, but I would amend "complete history" to "some history, depending on the kind of journal". Teradata has several kinds of journals, each serving a different purpose. For...
29622 Jul 2010 @ 10:45 PDTDatabaseReplyOracle concept of a SEQUENCE You can look in the release summary, but I can tell you that version 13 doesn't have that feature.
29521 Jul 2010 @ 11:40 PDTDatabaseReplyUDT Data TypeFINAL is part of the ANSI/ISO standard SQL syntax. In Teradata, its only purpose is to conform to the standard syntax for declaring distinct types. In implementations that support type inheritanc...
29420 Jul 2010 @ 11:35 PDTDatabaseReplyExecution modes in teradataThe execution modes pertain only to external stored procedures and UDFs. In protected mode, the function runs in a separate process; in unprotected mode the function is called directly by the AMP ...
29309 Jul 2010 @ 05:56 PDTGeneralReplyQuestion on Partitioning:: Full table lock or only Partition Lock?There is no partition level locking in Teradata - yet.
29206 Jul 2010 @ 03:52 PDTDatabaseReplyteradata system restartThe system restart would rollback any open transactions, but the contents of global temporary tables would persist, and the sessions would be automatically recovered (at least if the client is BTEQ...
29106 Jul 2010 @ 12:14 PDTDatabaseReplyCreating a Procedure to turn off Online Archiving - Need help!OVERRIDE is not a command. It is an optional part of the syntax of the LOGGING ONLINE ARCHIVE OFF statement. See the SQL manual for details.
29023 Jun 2010 @ 08:55 PDTDatabaseReplyimprove peformance by using functions instead of coalesceThe cost of checking for null values using the coalesce function should be minimal compared to the cost of accessing the row. Any reference to a nullable column in your SQL will generate internal ...
28922 Jun 2010 @ 10:41 PDTDatabaseReplyReg CLOB variableYes ( At least for all currently supported releases).
28816 Jun 2010 @ 11:15 PDTAnalyticsReplyusing dbc.tablesize, determine total tablesize for a specific userThe information in DBC.TableSize is maintained for all tables and is not affected in any way by the use of "collect statistics". This query will show the disk space used by each table you have c...
28715 Jun 2010 @ 04:39 PDTDatabaseReplylength of the stringUse the standard SQL function CHARACTER_LENGTH.
28609 Jun 2010 @ 10:54 PDTDatabaseReplyProblem creating NOPI tableAgain, the removal of duplicate rows is a FastLoad problem. Try using a different insert method, such as MultiLoad or regular SQL.
28508 Jun 2010 @ 11:22 PDTDatabaseReplyProblem creating NOPI tableThe No-PI table is a feature that was introduced in version 13.0. Anyway, as far as I know, there is no automatic elimination of rows on insert into a multiset table unless you are using FastLoad...
28404 Jun 2010 @ 11:16 PDTCloud ComputingReplySUSE VMware image of TD13 Express dies intermittentlyThe only thing this tells me is that none of the top CPU users are Teradata processes. Perhaps you should raise this issue in a Linux forum.
28302 Jun 2010 @ 10:38 PDTDatabaseReplyPermSpace RelatedHow many AMPs are there in your system? An empty table will use a minimum of 512 bytes on each AMP, so 77KB would be the approximate expected space usage for a smallish (150 AMP) system. The actu...
28217 May 2010 @ 03:26 PDTDatabaseReplyConverting Timestamp to timestamp with time zoneThe FORMAT specifier is only meaningful if the value is either (a) exported in report form, as to BTEQ, or (b) with CAST when converting to or from a character type. SQL Assistant does not suppo...
28114 May 2010 @ 10:29 PDTConnectivityReplyMERGE & ODBCThe error appears to be from the Teradata SQL parser, so it is probably not specific to ODBC. Prior to 12.0, the syntax of the merge statement was rather limited. If you post the complete merge sta...
28013 May 2010 @ 11:56 PDTDatabaseReplyMACRO DEFAULT VALUEThe syntax for the DEFAULT phrase does not allow arithmetic expressions.
27912 May 2010 @ 11:12 PDTToolsReplyRunning select while mloadAssuming the select statement is with default (read) locking... (1) Mload will wait until the select statement finishes. (2) The select statement will wait until Mload finishes.
27812 May 2010 @ 10:59 PDTDatabaseReplyTemporary Tables in TeradataA view does use a (usually) trivial amount of perm space due to dictionary rows. Since those rows are in system tables, DBC.TVM and DBC.TVFields, the space is charged to DBC. The creation of a ...
27712 May 2010 @ 10:46 PDTGeneralReplybig scale loadingMload blocks selects with read locks but allows access locks (i.e., read-uncommitted) during the final loading phase. There are no restrictions on selects during the data acquisition phase (when th...
27607 May 2010 @ 01:27 PDTToolsReplyVolatile Table "Disappears" while BTEQ job is running? - Failure 3807As far as I know, the only thing that can make a volatile table disappear like that is a database system reset. In that event the session would be recovered, and BTEQ (by default) would resubmit t...
27506 May 2010 @ 11:34 PDTUDAReplyTeraData vs OracleNot exactly. By default, transactions in Teradata are fully serializable with all the ACID properties. A read-uncommitted mode is available as an option for a query, but any transaction that upd...

Pages