#DateForumTypeThreadPost
7426 Jul 2007 @ 04:01 PDTToolsReplyWhich teradata utility support Upsert logic from oracle to Teradata ?BTEQ (and all the Teradata client APIs, such as ODBC) support a limited form of upsert (single row, no FROM table or subquery allowed).A limited form of the MERGE statement (from ANSI SQL:2003) was...
7323 Jul 2007 @ 04:44 PDTDatabaseReplyTeradata V2R^ comparisonYour best sources for that information are the Release Summary documents, which are available on the publication download page of this website. V2R6 (with subsequent V2R6.1 and V2R6.2 minor releas...
7223 Jul 2007 @ 12:05 PDTDatabaseReplylog fileThe host node of the PE that is assigned to serve a session isn't always the same as the node that has the network client connection. To determine the latter, one method might be to execute some t...
7113 Jul 2007 @ 01:58 PDTDatabaseReplyhow to "purge" transient journalYou didn't say which Teradata version you are running. With V2R6.2 and later, the TJ is also used by the file system as a write-ahead log, which greatly increases the amount of disk space used. T...
7012 Jul 2007 @ 08:02 PDTDatabaseReplyteradata shutdown itselfIt's a bug, most likely DR110738. You should be able to get the fix from the Teradata support center.
6909 Jul 2007 @ 12:52 PDTDatabaseReplyNew line character in Dynamic SQL.It depends on the host programming language. For instance, in C or C++ you could code "\n" at any point within the string to generate a newline character.
6826 Jun 2007 @ 07:27 PDTDatabaseReplyImport - Duplicate row errorPossible solutions:1. Load the data into a multiset table. If the target table must be a set table, you can "insert ... select" into the target table from the multiset table, and duplicate rows wi...
6720 Jun 2007 @ 01:51 PDTDatabaseReplyChecksum AttributeI believe the table checksum attribute was intended for the supposedlyrare cases when it was necessary to override the system-wide defaultsettings.You can use the DBSCONTROL utility to set the chec...
6614 Jun 2007 @ 02:03 PDTDatabaseReplyMax Row LenghthJust one small correction to joedsilva's excellent explanation: The maximum LOB size is actually 32767*64000 = 2,097,088,000 bytes.
6514 Jun 2007 @ 01:28 PDTDatabaseReplyMS Word document as LOBCurrently, support for importing or exporting LOB data via the client utilities is very limited. The best-supported interfaces are the ODBC and JDBC APIs. I am not knowledgeable about MS Access, ...
6412 Jun 2007 @ 01:22 PDTUDAReplyPartition In Global TempSupport for partitioned volatile and global temporary tables was implemented in version V2R6.1. I tried your SQL statement on my V2R6.1 system, and it executed successfully.
6318 May 2007 @ 03:26 PDTUDAReplyMloADNo, MLOAD does not process select statements, nor does it allow subqueries in DML statements. To assign a value from a query, one method would be to execute an update statement in BTEQ. Use a corr...
6214 May 2007 @ 01:15 PDTUDAReplyMultiLoad and the Check ConstraintYes.
6103 May 2007 @ 01:40 PDTDatabaseReplyHow to view statistics?The collected statistics are stored in DBC.TVFields.FieldStatistics and DBC.Indexes.IndexStatistics.They can be viewed in a more readable but highly abbreviated form using the "help statistics" SQL...
6026 Apr 2007 @ 12:25 PDTToolsReplyColumn gets truncated and gets insertedIf you execute the request in ANSI session mode, truncation will raise an error condition. In "BTET" mode, truncation is accepted without raising an error.
5920 Apr 2007 @ 06:16 PDTToolsReplyConnecting to TD using Perl (ODBC)Could the problem be that you reference a different (possibly unintialized) variable "$thisdsn" instead of "$dsn"?
5816 Apr 2007 @ 03:48 PDTDatabaseReplyReverse string search (right to left)?The UDF solution requires Teradata version V2R5.1 or later.
5716 Apr 2007 @ 03:46 PDTAnalyticsReplyTransfer data from one server to another.For replicating tables, take a look at the Teradata Replication Solutions product. If you just want to copy a table on an ad hoc basis, consider using the "copy" command of archvive/recovery utility.
5612 Apr 2007 @ 09:21 PDTDatabaseReplyNegative spool spaceIt's a bug. There have been several bug fixes in that area in recent years, the latest being in release 6.2.
5512 Apr 2007 @ 09:19 PDTDatabaseReplystring with single quotesDouble the single-quote inside a string to get a literal single quote. For example:select '''foo''' as foo; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 se...
5412 Apr 2007 @ 09:01 PDTDatabaseReplyPermanent JournalsPermanent journals provide the ability for the user to execute roll-back or roll-forward operations between user-defined checkpoints.
5306 Mar 2007 @ 01:38 PSTDatabaseReplyHow to recover a table once its droppedFallback doesn't help you recover a dropped table. Your only recovery options are to restore it from a previously archived copy or reload it from source data.
5202 Mar 2007 @ 04:03 PSTDatabaseReplyLPAD Function equivalent in Teradataselect SEQ_NO (format '9999') ... ;
5101 Mar 2007 @ 03:44 PSTDatabaseReplyTeradata TPUMP utility Performance ImprovementConsider Multiload as an alternative to TPUMP if the target tables don't have unique secondary indexes or referential constraints (which are not supported by Multiload).If Multiload is not suitable...
5021 Feb 2007 @ 01:51 PSTDatabaseReplySecurity Token - Replication groupThe security token is intended to provide a simple way to authenticate the external replication TCP/IP client. It is like a password, except that it is always generated by the Teradata server. Si...

Pages