#DateForumTypeThreadPost
14923 May 2008 @ 12:16 PDTDatabaseReplyInstalling Teradata 12.0 - Not workingThere should be an error event in the Event Log that will indicate why Teradata failed to start. Use the Microsoft Event Viewer accessory to view the Event Log.
14806 May 2008 @ 01:10 PDTDatabaseReplyHow to Stop ransient Journal?I believe the other respondent was trying to tell you that the transient journal cannot be stopped, which is correct.
14715 Mar 2008 @ 12:22 PDTUDAReplyAny DBC tables to find the row length of a table?No, not directly. You should be able to estimate the length by adding the lengths of the columns. Another estimating method that could be used for a populated table to get the the amount of disk ...
14615 Mar 2008 @ 12:16 PDTUDAReplyLocked tableThere is a console utility called LOKDISP. Look it up in the Teradata Utilities Manual.
14510 Mar 2008 @ 05:41 PDTDatabaseReplyavoid exclusive lock during inserts on a tableSome of us may have assumed that when you mentioned "simple insert" you meant a single-row insert. We tend to use the term "bulk insert" when referring to an insert that is sourced from a query ex...
14406 Mar 2008 @ 02:05 PSTDatabaseReplyDB Size100 GB is tiny database by today's standards. Even if it grows to 100 TB, Teradata should handle it easily.
14303 Mar 2008 @ 12:29 PSTDatabaseReplyRestoring System from 64bit Linux to 32 bit LinuxYou are asking about an impossible scenario. As far as I know, there was never any released version of Teradata that ran on a 32-bit Linux platform. Our Teradata for Linux releases have always bee...
14227 Feb 2008 @ 08:05 PSTDatabaseReplydemo questionTwo utilites, sysinit and reconfig, are intentionally omitted from the demo distribution.
14127 Feb 2008 @ 11:37 PSTDatabaseReplyMaximum no. of columns in table1. We like to specify a limit because that establishes a testing criterion. You can be sure that we actually create tables with 2048 columns and attempt to create tables that exceed the limit as ...
14025 Feb 2008 @ 11:06 PSTConnectivityReplyWindows 2003 SP1 and Demo CD to have UDF workingYou may be getting an access violation when Teradata attempts to execute some generated machine code. SP1 implemented a new memory protection feature known as "Data Execution Protection". http://...
13918 Feb 2008 @ 01:20 PSTDatabaseReplyLT,WT,ET,UV tablesMultiLoad has an ERRLIMIT option, which specifies the number of errors that will be tolerated without causing the entire load operation to fail. If I remember correctly, the default is 1,000,000.
13818 Feb 2008 @ 01:17 PSTDatabaseReplyDelete ALL taking too longIs the delete executing in ANSI transaction mode? If so, the fast delete method is not used. The use of certain table options, such as permanent journals or replication, can also make delete oper...
13718 Feb 2008 @ 01:14 PSTDatabaseReplyALTER TABLE and transient journalAlter table does use the transient journal to log dictionary and table header changes, but these are very low volume. It does not, under any circumstances, log changes at the data row level. Even ...
13614 Feb 2008 @ 02:07 PSTConnectivityReplyCONVERT MERGE STATMENT INTO UPSERT STATMENTThe MERGE INTO syntax is supported in Teradata release 12.0.
13513 Feb 2008 @ 07:59 PSTDatabaseReplyconvert byte data into varcharYou cannot directly convert byte or varbyte to any other type using Teradata SQL, but you could write a UDF that accepts arguments of one type and returns a value of some other type.
13408 Feb 2008 @ 01:12 PSTDatabaseReply"Expalin" explaination neededAbort tests are typically generated to validate the request against some required precondition. For instance, a CREATE USER statement must fail if the name already exists. Therefore a single-AMP ...
13331 Jan 2008 @ 12:18 PSTConnectivityReplyHow to write UDF to handle operating System I/O operationsBear in mind that, even with an external procedure, you normally don't have control over which node the procedure executes on.
13224 Jan 2008 @ 04:19 PSTDatabaseReplyOracle to Teradata MigrationTeradata's MERGE statement (as of 12.0) has some extended syntax that allows an "error table" to be specified, and then errors that are encountered during the merge (e.g. constraint violations) are...
13124 Jan 2008 @ 04:10 PSTDatabaseReplyFetching Page Size from Teradata tables"Tempory Storage Page Size" controls only the management of scratch memory within the RSG with the replication feature. If you are not using replication, it is immaterial.By "page size", if are th...
13024 Jan 2008 @ 04:01 PSTDatabaseReplyTime interval for AmpUsage viewAmpUsage is cumulative by user and account name. For finer granularity, just vary the account name over time. You can use the "account string expansion" feature to have this done automatically for...
12922 Jan 2008 @ 12:23 PSTDatabaseReplyDBQLogTbl ProcIDThe owner VPROC is always a PE. Query logs are maintained by the PE, and the PE does not have detailed information about the participating AMPs.
12817 Jan 2008 @ 02:47 PSTDatabaseReplyimplementing Patch on TeradataPatches and version upgrades are usually applied using the Parallel Update Tool (PUT).
12714 Jan 2008 @ 07:53 PSTUDAReplyStrange Error in Time(n)The insert values list is one of the places where NULL is explicitly allowed, according to the SQL standard.
12611 Jan 2008 @ 02:42 PSTDatabaseReplyREPLACING OR CREATING MULTIPLE MACROSSince macro definition statements are DDL, they are not allowed in multi-statement requests, nor are multiple DDL statements allowed in one transaction.
12511 Jan 2008 @ 02:01 PSTUDAReplyStrange Error in Time(n)I should have added that Teradata, as an extension to standard SQL, allows NULL in the context of a value expression, with the default type of Integer.select type(null); Type(Null)-----------------...

Pages