446 | 01 Dec 2012 @ 05:05 PST | Private Forum |
445 | 01 Dec 2012 @ 11:09 PST | Database | Reply | How to install external UDF libraries on Hot Standby Node (HSN)? | Any user or third party code needs to be installed / compiled using DDL (optionally via supplied "package" SPs) as documented in the SQL Reference "External Routine Programming"... |
444 | 01 Dec 2012 @ 10:47 PST | Tools | Reply | Mload table locks cannot be released because NUSI exists | In normal SQL operations, whenever a change is made to a row in the table, any corresponding update to secondary indexes or join indexes happens immediately. MultiLoad does not work that way.
Inst... |
443 | 11 Nov 2012 @ 08:57 PST | Database | Reply | Left outer join with a NULL value | Using your simplified example above, I get three rows returned as expected - though of course the answer set has six columns instead of 5 because column A.A and B.A are both included. Perhaps you n... |
442 | 06 Nov 2012 @ 08:27 PST | Database | Reply | show view does not show databasename in viewname | Try SHOW QUALIFIED SELECT * FROM db.viewname;
|
441 | 31 Oct 2012 @ 08:40 PDT | Extensibility | Reply | UDF compiled but fails to run "corrupt stack frame" | The inputString parameter should be referenced only, not modified.
|
440 | 25 Oct 2012 @ 11:26 PDT | Database | Reply | to_char function in stored procedure | TRIM returns VARCHAR. Even if you have TO_CHAR UDF (e.g. TD14), there is no specific function prototype for TO_CHAR that accepts VARCHAR arguments. So remove TRIM and pass the numeric value re... |
439 | 23 Oct 2012 @ 02:23 PDT | Database | Reply | Multiload Concatenation Field Query | In the first case, three parameters are sent to Teradata and then the database does the concatenation. In the second case, the client on which MultiLoad is running does the concatenation and t... |
438 | 23 Oct 2012 @ 02:04 PDT | Database | Reply | FastLoad Error table being dropped | By default, the err1 table will be dropped if it is empty. And the only reason for rows in FastLoad err2 is that the target table is defined with a unique Primary Index but there are duplicate PI v... |
437 | 23 Oct 2012 @ 01:43 PDT | Database | Reply | to_char function in stored procedure | The to_char function is an ODBC extension and is being translated by the client driver.
Something like this should work:
cast(cast(cast(extract( month from table.date_column) as format '99... |
436 | 09 Oct 2012 @ 04:37 PDT | Tools | Reply | BTEQ data format question/DATE format issue | I am guessing that your time zone offset is a negative number.
All timestamps have an associated time zone, even if it's not explicitly specified or stored. Since you didn't specify a time... |
435 | 06 Oct 2012 @ 09:49 PDT | Connectivity | Reply | "Invalid date supplied for" error | The problem is that MS Query binds "DATE" columns as SQL "TIMESTAMP", while in Teradata these are completely different data types. Under Options, Advanced there is a c... |
434 | 16 Sep 2012 @ 09:30 PDT | General | Reply | A Wish List for future versions of Teradata. | No CASE required; if you know that the value will properly fit in 2 characters you can apply explicit FORMAT:
CAST(CAST(DAYS_EARN_MO_NBR AS FORMAT '99') AS CHAR(2))
As Ulrich pointed out,... |
433 | 04 Sep 2012 @ 09:10 PDT | Viewpoint | Reply | Viewpoint configuration problem |
When you look at Admin / Teradata Systems, are there red triangles by the data collectors? If so, hover the mouse cursor over them to see the error details.
You could also try restarting the... |
432 | 01 Sep 2012 @ 09:06 PDT | Database | Reply | Problems with dynamic creation of Volatile tables |
Since you are specifying NoPI (vs. trying to copy the existing PI):
CREATE VOLATILE TABLE myTemp AS (SELECT * FROM SourceDb.SourceTable)
WITH NO DATA NO PRIMARY INDEX ON COMMIT PRESERVE ... |
431 | 17 Aug 2012 @ 12:51 PDT | Database | Reply | Compress in Teradata,how it works?? |
1) First two examples compress only NULL.
Third one compresses the default value and four others, in addition to NULL.
2) The obvious way is to create two copies of the table,... |
430 | 17 Aug 2012 @ 12:30 PDT | Database | Reply | Dynamic SQL with EXECUTE and EXECUTE IMMEDIATE |
EXECUTE IMMEDIATE is the ANSI equivalent of Teradata "CALL dbc.SysExecSQL()". [The argument for either is a character string that contains a SQL statement.]
EXECUTE requires separa... |
429 | 11 Aug 2012 @ 02:38 PDT | General | Reply | Informatica/ Teradata INSERT Access WITH GRANT Issue while Loading |
Or just GRANT INSERT ON target database or table TO macro database WITH GRANT OPTION.
|
428 | 11 Aug 2012 @ 02:17 PDT | Database | Reply | Changing column datatype from DECIMAL(9,0) to DECIMAL(15,0) |
You have to create a new table and copy the data for this change. Some types of changes can be done with ALTER TABLE, but not DECIMAL(9) to DECIMAL(15).
COMPRESS 0 means that if the value in... |
427 | 11 Aug 2012 @ 01:50 PDT | Database | Reply | Foreign key constraint-does it impacts performance |
It depends.
If you define a standard REFERENCES constraint then it will be validated for every child row insert/update and every parent row update/delete. This clearly imposes a perform... |
426 | 11 Aug 2012 @ 01:13 PDT | Tools | Reply | TPUMP Behaviour |
Check TPUMP manual for SERIALIZE option. By default, SERIALIZE is OFF except for "upsert".
|
425 | 11 Aug 2012 @ 12:56 PDT | Viewpoint | Reply | About Viewpoint in Express 13.10 |
The embedded instance of Viewpoint is configured to use the default http port 80, so the URL is just http://localhost (assuming it is running).
|
424 | 11 Aug 2012 @ 12:40 PDT | Cloud Computing | Reply | How to connect to Teradata Express for Amazon EC2 from SQL Assistant? |
First you must grant permission for port 1025 to be accessed remotely. See configuration help on this site, e.g.
http://developer.teradata.com/database/articles/teradata-express-14-0-for-ec2... |
423 | 11 Aug 2012 @ 09:36 PDT | General | Reply | Updates to Teradata Documentation |
The date shown on the www.info.teradata.com is not the revision date of the manual or CD. If you download the individual SQL Fundamentals manual, it is the same August 2010 revision in... |
422 | 06 Aug 2012 @ 10:25 PDT | Private Forum |