#DateForumTypeThreadPost
12411 Jan 2008 @ 01:38 PSTUDAReplyStrange Error in Time(n)insert into A (col_a)selnull as col_afrom B; *** Failure 5407 Invalid operation on an ANSI Datetime or Interval value.The problem is that, in standard SQL, NULL is not a general value expression. ...
12309 Jan 2008 @ 01:20 PSTToolsReplyReconfiguration program (a Teradata Database support utility)In general, there is no need to run reconfig except when adding or removing AMPs. Reconfig is *not* a tool for "tweaking" the system to improve performance.
12208 Jan 2008 @ 03:06 PSTDatabaseReplyPartioned Primary Index TableThis seems to be a recurring question. See the following discussion thread:http://www.teradata.com/teradataForum/Topic6553-9-1.aspx?Highlight=PPI+UPI
12108 Jan 2008 @ 01:43 PSTToolsReplyReconfiguration program (a Teradata Database support utility)Its most common use is to add AMPs to the system. It is used by the Teradata field engineer after installing new hardware (nodes or disks). It computes a new hash map and then redistributes the ex...
12007 Jan 2008 @ 01:49 PSTToolsReplyNo. of sessions in mload.The session usage for FastLoad is the same as for MultiLoad. TPUMP only uses SQL sessions, and AFAIK does not require extra sessions for control or logging.
11907 Jan 2008 @ 01:41 PSTDatabaseReplyExtracting month from date as 'MMM'My previous suggestion only works in BTEQ. Normally, output formatting is controlled by the client program, but you can use the CAST operator to force the Teradata server do the conversion.For exa...
11804 Jan 2008 @ 03:08 PSTDatabaseReplyExtracting month from date as 'MMM'select current_date (format 'MMM'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second.Date---- Jan
11704 Jan 2008 @ 01:28 PSTToolsReplyNo. of sessions in mload.MultiLoad uses 2 SQL sessions (for control and logging, respectively) plus a variable number of load sessions, which is specified by the SESSIONS parameter in the BEGIN MLOAD control statement. Th...
11617 Dec 2007 @ 02:55 PSTConnectivityReplyCan a UDF call an External Stored ProcedureNo, to both questions.
11511 Dec 2007 @ 02:00 PSTDatabaseReplyIncorrect answerset.You might want to read the topic "Implicit Type Conversion of Character Operands" in the Teradata SQL reference manual. When comparing a numeric value to a character value, both operands are first...
11405 Dec 2007 @ 02:45 PSTDatabaseReplyClearing TJournalsI think the problem is likely to recur from time to time until you apply the fix.
11304 Dec 2007 @ 01:32 PSTDatabaseReplyClearing TJournalsThe only safe way to forcibly purge the transient journal is to restart the database. Ordinarily, that should never be necessary, as the system continually removes TJ records for completed transac...
11215 Nov 2007 @ 01:17 PSTDatabaseReply.osm logs on OS/var/log/messages
11115 Nov 2007 @ 01:09 PSTAnalyticsReplyANSI vs. Teradata SQLThe latest SQL standard, (SQL:2003, soon to be superseded by SQL:2008) is vast. Teradata implements a very large subset (perhaps 95%) of the SQL:2003 Core language as defined by the standard, whic...
11007 Nov 2007 @ 02:22 PSTConnectivityReplyDevelop UDF's in JavaTeradata UDFs must be written in C or C++. Java is not supported. As of release 12.0, Java stored procedures are supported on Linux and Windows 2003 platforms.
10905 Nov 2007 @ 03:15 PSTToolsReplyTeradata Manager internal queriesTeradata Manager uses an interface called PM/API to retrieve performance data. See the PM/API reference manual for more info.
10805 Nov 2007 @ 01:28 PSTDatabaseReplyAny Guru can advice on Teradata on Linux Vs Teradata on WindowsSure. Just post your specific questions here.
10701 Nov 2007 @ 12:15 PDTDatabaseReplyInserting rows in DBQRYLOGTBLDBC.QryLogTbl is a system table. You cannot update it directly.
10601 Nov 2007 @ 12:12 PDTDatabaseReplyhow to release lock on a fastload connection?You could also re-execute fastload with the same script. It should resume loading from the last checkpoint.
10515 Oct 2007 @ 11:46 PDTDatabaseReplyHow to find when the table was updated in Teradata Database?The system does not maintain LastAccessTimestamp unless the "object use counts" feature is activated. Use the DBSCONTROL utility to turn it on. As I understand it, this would give you the time th...
10403 Oct 2007 @ 05:27 PDTUDAReplyTIMESTAMPThere is a related known problem, DR 114070: "CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP do not return the correct value for the default session time zone. Instead, they returned the year, m...
10303 Oct 2007 @ 03:43 PDTUDAReplySorting Numbers Stored As StringThe cast expression can be given a different name. Then you can reference the original column name in the "order by", e.g.:select cast(b as char(4)) as b1 from t1 order by b; *** Query completed. ...
10202 Oct 2007 @ 04:29 PDTToolsReplyBteq Vs MLYou need to be more specific about the kinds of logical operations you require. Evidently they are not simple inserts, or you could just insert directly from your work table. If the operations in...
10128 Sep 2007 @ 01:05 PDTToolsReplyAll-Amp backup and Cluster BackupCluster backup allows multiple ARCMAIN client processes to be executed in parallel. Each client process writes to its own archive. An all-AMP backup executes in a single client process and produc...
10021 Sep 2007 @ 01:56 PDTDatabaseReplyRegarding Row Alignment on Even Bytes!!The even-byte alignment rule is not for performance. It is due to a constraint on row addressing within the data block. Space in each data block is managed as a heap, i.e., the physical order of ...

Pages