#DateForumTypeThreadPost
42120 Dec 2010 @ 02:36 PSTDatabaseReplyshow view this is showing some what diffentMost likely ARC COPY with FROM option was used to restore the database and/or view with another name. But that only changes the "external" name not the definition; and for views, SHOW returns the o...
42006 Dec 2010 @ 01:49 PSTToolsReplyProblem to load data into teradata table by using tptBecause the DML statement is already a quoted string, you need to use two single quotes in a row inside the SUBSTR to produce a single quote in the statement text. But inserting spaces doesn't leav...
41917 May 2010 @ 01:34 PDTExtensibilityReplyUDF - pass dates to create factorYour function prototype needs a pointer to the result field, between the input parameters and the indicator fields. And don't declare the result as a local variable.
41826 Apr 2010 @ 12:50 PDTDatabaseReplyWhen does outer join become inner?Perhaps you are referring to the case where the optimizer determines that the filter (WHERE) criteria will eliminate all rows in the result that would have had NULLs due to no match in the inner ta...
41728 Mar 2010 @ 09:01 PDTDatabaseReplyMulti-Partitioning - how to hit the partition?You can't get "static" partition elimination, but you may be able to get a join plan that is "enhanced by dynamic partition elimination". What stats have you collected on t_day? How about multicolu...
41628 Mar 2010 @ 08:52 PDTDatabaseReplydifference of values with datatype TimeBut duration would be an INTERVAL datatype. It's logically incorrect to assign an INTERVAL value to a TIME field. If you absolutely insist on storing the result as TIME(0) instead of the proper typ...
41514 Mar 2010 @ 02:48 PDTDatabaseReplydifference of values with datatype TimeFirst, verify that your column is really a TIME field. (The ODBC parser may substitute FLOAT when you specify TIME if the middle letter in DateTimeFormat is I.) Use SHOW TABLE or HELP COLUMN or que...
41405 Mar 2010 @ 09:35 PSTDatabaseReplyvarchar concatenationIn your CASE expression, ideally the datatypes of all the alternative expressions (WHEN/ELSE clauses) should match. If not, Teradata must try to guess which data type you intended for the result, a...
41331 Oct 2009 @ 01:12 PDTDatabaseReplyhow to abort session without PEMON or TDManager ?In TD12.0 or later, check out the "Open API" SQL functions (documented in the Workload Management API manual).
41226 Oct 2009 @ 06:43 PDTDatabaseReplySkew issueNote that "CREATE AS SELECT" is creating the table from a spool file (resulting from the SELECT), not from the source table. Most table attributes are not carried forward; in particular, the system...
41130 Sep 2009 @ 10:38 PDTToolsReplyMultiple Sessions Setting in Teradata Tools and utilitiesYour script says to call SP1 four times; then call SP2, SP3, SP4 each one time, in sequence. Only the four calls to SP1 are eligible to use the parallel sessions. To run four different stored pr...
41030 Sep 2009 @ 10:17 PDTDatabaseReplyDBQLSQLTbl's logging timeCollectTimeStamp supports efficient blocking & deferred writing of log rows. The value is the same for all rows in the same memory buffer (but each log table has its own buffers). CollectTimeStamp ...
40913 Aug 2009 @ 11:59 PDTToolsReplyMultiple Sessions Setting in Teradata Tools and utilitiesIn general, multiple sessions allow for parallelism when transferring data between the client and the Teradata database. In the case of BTEQ, multiple sessions are only useful in conjunction wit...
40828 Jul 2009 @ 11:43 PDTDatabaseReplyWhere do I get Teradata Express Edition 12.0 for LinuxExpress Edition 12.0 is available only for 32-bit Windows platform
40728 Jul 2009 @ 11:41 PDTToolsReplyI cant log into Teradata ManagerIn interactive mode, you must be prompted for the password; you only supply it in the logon statement when running in batch / script mode.logon localtd/dbc(assuming your hosts file has localtdcop1 ...
40624 Jul 2009 @ 01:17 PDTToolsReplyGetting error in fastloadTRIM function returns VARCHAR.First choice: remove TRIM from the non-character fields in FastExport step.Second choice: change DEFINE in FastLoad to VARCHAR for those fields.
40522 Jul 2009 @ 07:22 PDTDatabaseReplyanother Compression QuestionIn current releases of Teradata, as long as compressed columns are simply copied into the spool then they remain compressed.
40417 Jul 2009 @ 03:37 PDTDatabaseReplyJoined table updateThe main thing is you're not allowed to qualify the column name on the left-hand side of the SET clause at all. Omitting the alias on the target table, syntax would be: update login.table_aggreg...
40311 Jul 2009 @ 01:02 PDTDatabaseReplyAdding AMPS to existing systemYes to both questions. See documentation for the RECONFIG utility.
40211 Jul 2009 @ 01:00 PDTAnalyticsReplyTeradata adminIt's not enough to be permitted to use the role, User1 needs to "assert" the role to actually inherit the permissions. That can be executing an explicit SET ROLE statement after logon, or more like...
40112 Jun 2009 @ 08:51 PDTDatabaseReplyStats on non index columnFor a simple query, you are correct that stats on non-index columns merely give you a better cardinality estimate (and don't change the query plan). But it may be important to have that more accura...
40011 Jun 2009 @ 04:49 PDTDatabaseReplyARCMAINNote that COPY and RESTORE are different.If you COPY the content of a database to a different system, that's exactly what you get - copies of the content of that one database. Copies of objects get...
39910 Jun 2009 @ 02:06 PDTUDAReplyTIMESTAMP INTERVAL NOT WORKING IN BATCH JCL (BUT WORKS IN SQL ASSISTANT)I suspect you have the "allow use of ODBC extensions" option checked in SQL Assistant, and the DDL and/or DML you enter is being modified by the ODBC driver before sending it to Teradata.Do a SHOW ...
39809 Jun 2009 @ 03:39 PDTDatabaseReplyGetting result in order from Select query.....The sequence appears to be constant because this is such a simple example. In the general case, you cannot rely on any implicit ordering.
39709 Jun 2009 @ 01:42 PDTDatabaseReplyQuery to find out the table name and the columns of that table associated with a viewThe Teradata "Meta Data Services" component (included with "Teradata Utility Pack") includes the necessary parsing logic to document these dependencies.

Pages