#DateForumTypeThreadPost
44601 Dec 2012 @ 05:05 PSTPrivate Forum
44501 Dec 2012 @ 11:09 PSTDatabaseReplyHow 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"...
44401 Dec 2012 @ 10:47 PSTToolsReplyMload table locks cannot be released because NUSI existsIn 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...
44311 Nov 2012 @ 08:57 PSTDatabaseReplyLeft outer join with a NULL valueUsing 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...
44206 Nov 2012 @ 08:27 PSTDatabaseReplyshow view does not show databasename in viewnameTry SHOW QUALIFIED SELECT * FROM db.viewname;
44131 Oct 2012 @ 08:40 PDTExtensibilityReplyUDF compiled but fails to run "corrupt stack frame"The inputString parameter should be referenced only, not modified.
44025 Oct 2012 @ 11:26 PDTDatabaseReplyto_char function in stored procedureTRIM 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...
43923 Oct 2012 @ 02:23 PDTDatabaseReplyMultiload 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...
43823 Oct 2012 @ 02:04 PDTDatabaseReplyFastLoad Error table being droppedBy 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...
43723 Oct 2012 @ 01:43 PDTDatabaseReplyto_char function in stored procedureThe 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...
43609 Oct 2012 @ 04:37 PDTToolsReplyBTEQ data format question/DATE format issueI 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...
43506 Oct 2012 @ 09:49 PDTConnectivityReply"Invalid date supplied for" errorThe 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...
43416 Sep 2012 @ 09:30 PDTGeneralReplyA 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,...
43304 Sep 2012 @ 09:10 PDTViewpointReplyViewpoint 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...
43201 Sep 2012 @ 09:06 PDTDatabaseReplyProblems 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 ...
43117 Aug 2012 @ 12:51 PDTDatabaseReplyCompress 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,...
43017 Aug 2012 @ 12:30 PDTDatabaseReplyDynamic 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...
42911 Aug 2012 @ 02:38 PDTGeneralReplyInformatica/ Teradata INSERT Access WITH GRANT Issue while Loading Or just GRANT INSERT ON target database or table TO macro database WITH GRANT OPTION.
42811 Aug 2012 @ 02:17 PDTDatabaseReplyChanging 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...
42711 Aug 2012 @ 01:50 PDTDatabaseReplyForeign 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...
42611 Aug 2012 @ 01:13 PDTToolsReplyTPUMP Behaviour Check TPUMP manual for SERIALIZE option. By default, SERIALIZE is OFF except for "upsert".
42511 Aug 2012 @ 12:56 PDTViewpointReplyAbout 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).
42411 Aug 2012 @ 12:40 PDTCloud ComputingReplyHow 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...
42311 Aug 2012 @ 09:36 PDTGeneralReplyUpdates 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...
42206 Aug 2012 @ 10:25 PDTPrivate Forum

Pages