#DateForumTypeThreadPost
19924 Mar 2009 @ 12:52 PDTDatabaseReplyJournal Restore Error *** Failure 2852:As the message manual says, this is an internal error. That means the database software has malfunctioned. You should report the problem to your Teradata support representative.
19820 Mar 2009 @ 01:58 PDTDatabaseReplyInstalled but could not use itYou may be running into the infamous Windows DEP feature. Look in the Windows Event Log to see if a memory access exception was logged. Check out this URL for a detailed explanation of DEP:http://s...
19719 Mar 2009 @ 09:00 PDTToolsReplyWhy MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?This was answered in another thread:http://www.teradata.com/teradataforum/Topic14439-9-1.aspx
19617 Mar 2009 @ 01:38 PDTToolsReplyMload Vs FastloadFastLoad is generally faster when loading an empty table because FastLoad was designed specifically for that purpose. FastLoad can sort the incoming rows directly into the target table, whereas Mu...
19512 Feb 2009 @ 02:01 PSTDatabaseReplyUSI in multiloadEfficiently updating non-local objects such as secondary indexes and join indexes is indeed a more difficult problem than updating the base component of the table. However that very problem was su...
19410 Feb 2009 @ 01:51 PSTUDAReplywhy should we use SET table ?There's no reason to use a SET (as opposed to MULTISET) table if you don't need the automatic duplicatechecking. By the way, if a table has a uniqueness constraint defined on some set of columns (...
19305 Feb 2009 @ 12:49 PSTDatabaseReplycan we use cursors in bteqsBTEQ doesn't support cursors.
19230 Jan 2009 @ 04:04 PSTDatabaseReplyInsert/Update in a single statementYou will find complete documentation for MERGE INTO in the 12.0 version of "Teradata SQL Reference: Data Manipulation Statements" (B035-1146-067A).
19128 Jan 2009 @ 07:36 PSTDatabaseReplyInsert/Update in a single statementTake a look at the MERGE INTO statement as enhanced for Teradata 12.0.
19026 Jan 2009 @ 07:23 PSTToolsReplyconfiguring bteq access without /etc/hosts filesThe "names database" resides on your DNS name server. It provides a centralized solution to managing host name information for the local network (as an alternative to /etc/host files on every clie...
18921 Jan 2009 @ 06:18 PSTDatabaseReplyCYLINDER full conditionI don't believe Teradata has any such condition. Full cylinders are handled automatically. Perhaps you mean "full disk". If so, the remedy depends on what's causing disk space to be used up.
18820 Jan 2009 @ 01:06 PSTDatabaseReplystart DIP brings down PDE and DBSYou've probably hit the infamous Windows DEP problem. If so, you're getting an access violation when Teradata attempts to execute some generated machine code. You need to disable a Microsoft Windo...
18719 Jan 2009 @ 02:26 PSTDatabaseReplySystem restart and System hangA system hang is a condition that prevents any work from progressing. Typically, there will be little or no CPU activity when this occurs. On a saturated system, on the other hand, the CPUs are v...
18619 Jan 2009 @ 02:09 PSTDatabaseReplyTeradata System RestartNo, when the system restarts, existing sessions are recovered automatically. Any open transactions on those sessions are rolled back. The next request on each session will get a "retryable" error...
18515 Jan 2009 @ 02:01 PSTDatabaseReplyFastload from a mainframe (usage comp - format)I assume you are referring the COMP data type in IBM COBOL, which is a signed binary integer in twos-complement form. It may be 16, 32 or 64 bits wide. In Teradata, it should be declared as BIGIN...
18407 Jan 2009 @ 02:34 PSTDatabaseReplyInstalled teradata demo version 12.0I assume the product you mean is "Teradata Expresss Edition 12.0". In earlier versions, it was called a demo.There is no expiration. You are free to use it as long as you want for evaluation or d...
18305 Dec 2008 @ 02:13 PSTUDAReplyEssabse and Teradata 12.I don't know anything specific about that application, but Teradata releases are backward compatible.
18221 Nov 2008 @ 01:42 PSTAnalyticsReplyQuery teradata database using C programming UNIX platformConsider using ODBC as your programming interface to the database. It's generic and portable. Teradata ODBC drivers for various platforms can be dowloaded from www.teradata.com.Google "ODBC prog...
18119 Nov 2008 @ 07:10 PSTDatabaseReplyProblem while creating NUSIIf you do an "explain" for your "create index" statement, you may notice that it wants to insert rows into DBC.Indexes and DBC.ContraintNames. Since there is no more available space in the DBC dat...
18011 Nov 2008 @ 02:38 PSTDatabaseReplyLeft-over spool table foundYou hit a fault isolation action due to an internal malfunction. The system recovered by aborting yourquery. Usually the aborted query will run successfully when resubmitted.Some additional diagn...
17907 Nov 2008 @ 06:27 PSTDatabaseReplyReset identity column counterFor each table that has an identity column, there is a row in DBC.IdCols, and the column named AvailValue in that row has the next available sequence number. You can reset the sequence by updating...
17831 Oct 2008 @ 01:18 PDTDatabaseReplySetting up the databaseDBC.Tables is a view. I don't know anything about the demo version, but on the commercially sold versions,it is necessary to run the DIP program to create all the system views.
17728 Oct 2008 @ 02:25 PDTDatabaseReplyMERGE INTO IssueYes, a write lock prevents other transactions from getting either a read lock or a write lock on the object.
17628 Oct 2008 @ 02:20 PDTToolsReplyWindows V12 server with HP-UX UtilitiesYes, it certainly should be possible to connect from your client on HP-UX. Be aware that the clientsoftware expects the server host name to have the form "xxxxcop1" where xxxx is the server nameth...
17513 Oct 2008 @ 06:26 PDTDatabaseReplyHow to exit stored procedureNeither the SQL standard nor Teradata defines a return or exit statement for a stored procedure. However, you can use LEAVE with a statement label to achieve a similar effect. See the Teradata pu...

Pages