421 | 20 Dec 2010 @ 02:36 PST | Database | Reply | show view this is showing some what diffent | Most 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... |
420 | 06 Dec 2010 @ 01:49 PST | Tools | Reply | Problem to load data into teradata table by using tpt | Because 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... |
419 | 17 May 2010 @ 01:34 PDT | Extensibility | Reply | UDF - pass dates to create factor | Your 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. |
418 | 26 Apr 2010 @ 12:50 PDT | Database | Reply | When 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... |
417 | 28 Mar 2010 @ 09:01 PDT | Database | Reply | Multi-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... |
416 | 28 Mar 2010 @ 08:52 PDT | Database | Reply | difference of values with datatype Time | But 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... |
415 | 14 Mar 2010 @ 02:48 PDT | Database | Reply | difference of values with datatype Time | First, 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... |
414 | 05 Mar 2010 @ 09:35 PST | Database | Reply | varchar concatenation | In 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... |
413 | 31 Oct 2009 @ 01:12 PDT | Database | Reply | how 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). |
412 | 26 Oct 2009 @ 06:43 PDT | Database | Reply | Skew issue | Note 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... |
411 | 30 Sep 2009 @ 10:38 PDT | Tools | Reply | Multiple Sessions Setting in Teradata Tools and utilities | Your 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... |
410 | 30 Sep 2009 @ 10:17 PDT | Database | Reply | DBQLSQLTbl's logging time | CollectTimeStamp 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 ... |
409 | 13 Aug 2009 @ 11:59 PDT | Tools | Reply | Multiple Sessions Setting in Teradata Tools and utilities | In 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... |
408 | 28 Jul 2009 @ 11:43 PDT | Database | Reply | Where do I get Teradata Express Edition 12.0 for Linux | Express Edition 12.0 is available only for 32-bit Windows platform |
407 | 28 Jul 2009 @ 11:41 PDT | Tools | Reply | I cant log into Teradata Manager | In 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 ... |
406 | 24 Jul 2009 @ 01:17 PDT | Tools | Reply | Getting error in fastload | TRIM 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. |
405 | 22 Jul 2009 @ 07:22 PDT | Database | Reply | another Compression Question | In current releases of Teradata, as long as compressed columns are simply copied into the spool then they remain compressed. |
404 | 17 Jul 2009 @ 03:37 PDT | Database | Reply | Joined table update | The 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... |
403 | 11 Jul 2009 @ 01:02 PDT | Database | Reply | Adding AMPS to existing system | Yes to both questions. See documentation for the RECONFIG utility. |
402 | 11 Jul 2009 @ 01:00 PDT | Analytics | Reply | Teradata admin | It'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... |
401 | 12 Jun 2009 @ 08:51 PDT | Database | Reply | Stats on non index column | For 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... |
400 | 11 Jun 2009 @ 04:49 PDT | Database | Reply | ARCMAIN | Note 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... |
399 | 10 Jun 2009 @ 02:06 PDT | UDA | Reply | TIMESTAMP 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 ... |
398 | 09 Jun 2009 @ 03:39 PDT | Database | Reply | Getting 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. |
397 | 09 Jun 2009 @ 01:42 PDT | Database | Reply | Query to find out the table name and the columns of that table associated with a view | The Teradata "Meta Data Services" component (included with "Teradata Utility Pack") includes the necessary parsing logic to document these dependencies. |