#DateForumTypeThreadPost
24816 Jun 2009 @ 11:17 PDTDatabaseReplySpool or CPU usageHello,In my opinion, if this query is not to be executed at peak-times, lowering spool usage will lower the overall time considerably.But, it primarily depends on your preferences, usage and system...
24715 Jun 2009 @ 12:20 PDTDatabaseReplyUsing Dynamic Sql Stored ProcedureI believe, if you could provide the exact SP code and exact error, that would be of great help! :)
24615 Jun 2009 @ 07:42 PDTDatabaseReplyUsing Dynamic Sql Stored ProcedureHello,Four issues:1. Incomplete GROUP BY clause2. Invalid concatenation for columns3. Right-Parenthesis missing for SysExecSQL4. Semi-colon missing with CALL statementTry following:CREATE PROCEDURE...
24515 Jun 2009 @ 06:31 PDTDatabaseReplyHOW TO return last inserted row ?Hello,With only having an IDENTITY column and no Insert/Update Date/Timestamp, you cannot get the latest inserted row.Smilever, please note IDENTITY does not generate values in sequence.HTH!Regards...
24410 Jun 2009 @ 05:43 PDTUDAReplyneed mapping for clearing staging area?Hello,There can be many ways to do that, you don't necessarily require a separate job for that!For example, whenever you load data from any particular staging-table and there is no dependent job le...
24309 Jun 2009 @ 11:25 PDTDatabaseReplyGetting result in order from Select query.....Hello,Briefly, following are the observations:- Tables are not stored in particular order (just as Jim Chapman/Fred Pluebell replied)- Without specifying ORDER BY clause, you will not get data in p...
24204 Jun 2009 @ 05:36 PDTDatabaseReplyRounding Down in TeradataCREATE VOLATILE TABLE Table1 (Col1 DECIMAL(10,5)) ON COMMIT PRESERVE ROWS;INSERT Table1 (0.96);INSERT Table1 (1.56);SELECT Col1, CAST(col1 AS INTEGER) AS I ,Col1 - I AS D ,CASE WHEN (D < 0.9...
24103 Jun 2009 @ 05:42 PDTDatabaseReplyRounding Down in TeradataHello,Casting may not work for custom rounding .... how about a CASE statement?Regards,Adeel
24001 Jun 2009 @ 09:46 PDTAnalyticsReplyvolatile TableNot all objects, but Volatile tables!Regards,Adeel
23901 Jun 2009 @ 07:30 PDTAnalyticsReplyvolatile TableLet me rephrase what you described as follows:Suppose following:CT = Create TableCVT = Create Volatile TableT* = TimeT1: Session1 => CT => VT2 - DoneT2: Session1 => CVT => VT2 - ErrorT3...
23801 Jun 2009 @ 05:30 PDTAnalyticsReplyvolatile TableHello,Volatile Tables - VT Tables, are temporary tables which are created and populated/materialized under user's space. If not dropped explicitly, they are dropped when the session has ended!HTH!R...
23701 Jun 2009 @ 03:07 PDTDatabaseReplyTeradata PI and SI restrictionsWell, I would say there has to be some limit .... it cannot be unlimited .... as a matter of fact it wont make any sense and use as well!As compared to Oracle 11g or DB2 version 8, still Teradata 6...
23601 Jun 2009 @ 02:36 PDTDatabaseReplyTeradata PI and SI restrictionsHello,Perhaps because you may not encounter such versatile entity, which may not be normalized, may not be divided into sub-tables and contains more than 64 columns which are strong candidates for ...
23526 May 2009 @ 05:05 PDTUDAReplyInstr function in Oracle has to be replaced by Position FunctionHello,Following thread contains the answer of your question:http://www.teradata.com/teradataforum/Topic13579-1-1.aspx?Highlight=instrRegards,Adeel
23418 May 2009 @ 01:26 PDTDatabaseReplyTeradata SQL Assistant ( cross platform connection )http://www.teradata.com/teradataforum/Topic15465-1-1.aspxhttp://www.teradata.com/teradataforum/Topic15463-10-1.aspx
23318 May 2009 @ 01:24 PDTToolsReplyTeradata SQL Assistant ( cross platform connections )Hello,As it uses, ODBC connectivity, yes you can create DNS for any ODBC compliant DBMS and can connect to it!Regards,Adeel
23218 May 2009 @ 01:23 PDTConnectivityReplyTeradata SQL Assistant ( cross platform connection )Please do not post same question in multiple forums sub-sections!
23118 May 2009 @ 06:04 PDTConnectivityReplyhow to search for char ' and remove from the string "venkat's house"Following is the complete example, HTH:CREATE VOLATILE TABLE Table1(Col1 VARCHAR(20)) ON COMMIT PRESERVE ROWS;INSERT Table1 VALUES ('abc''s');INSERT Table1 VALUES ('abcd''s');INSERT Table1 VALUES (...
23018 May 2009 @ 05:45 PDTConnectivityReplyhow to search for char ' and remove from the string "venkat's house"Hello,First of all, you should decide whether only 1 instance is to be replaced or any number of instances!You can do that by either developing a UDF, or by using Teradata's built-in string functio...
22918 May 2009 @ 04:28 PDTConnectivityReplyHow to use cursors in UDFHello,No, you cannot use cursors in Teradata UDFs, infact Teradata UDFs are coded in C/C++, not in SQL like MS SQL Server.What you can do is to re-write the query with sub-query and get the desired...
22812 May 2009 @ 12:07 PDTTrainingReplynew to TeradataHello,As life is not as simple as drag n drop .... so you will have to write the SQL yourself! :)The documentation "SQL Reference: Fundamentals" available at following link, contains a full chapter...
22711 May 2009 @ 11:57 PDTDatabaseReplyCaseHello,Can you please explain what exactly you need to do?Regards,Adeel
22611 May 2009 @ 11:55 PDTDatabaseReplyVersion 12Hello,Following link contains the detailed answer of your question:http://www.teradata.com/teradataforum/FindPost13404.aspxRegards,Adeel
22511 May 2009 @ 04:57 PDTToolsReplyFastload utilityHello,Following example may be of some help:.SESSIONS 8;.LOGON dbc,dbc;DATABASE MyDB;ERRLIMIT 50000;DROP TABLE MyTable;DROP TABLE MyTable_Err1;DROP TABLE MyTable_Err2;CREATE TABLE MyTable(Col1 DATE...
22408 May 2009 @ 12:21 PDTDatabaseReplyFor loop problemHello,What exact error you are facing?If there is no error and you are not getting any rows as output, the reason may be missing "ON COMMIT PRESERVE ROWS" clause after "CREATE VOLATILE TABLE table_...

Pages