248 | 16 Jun 2009 @ 11:17 PDT | Database | Reply | Spool or CPU usage | Hello,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... |
247 | 15 Jun 2009 @ 12:20 PDT | Database | Reply | Using Dynamic Sql Stored Procedure | I believe, if you could provide the exact SP code and exact error, that would be of great help! :) |
246 | 15 Jun 2009 @ 07:42 PDT | Database | Reply | Using Dynamic Sql Stored Procedure | Hello,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... |
245 | 15 Jun 2009 @ 06:31 PDT | Database | Reply | HOW 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... |
244 | 10 Jun 2009 @ 05:43 PDT | UDA | Reply | need 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... |
243 | 09 Jun 2009 @ 11:25 PDT | Database | Reply | Getting 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... |
242 | 04 Jun 2009 @ 05:36 PDT | Database | Reply | Rounding Down in Teradata | CREATE 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... |
241 | 03 Jun 2009 @ 05:42 PDT | Database | Reply | Rounding Down in Teradata | Hello,Casting may not work for custom rounding .... how about a CASE statement?Regards,Adeel |
240 | 01 Jun 2009 @ 09:46 PDT | Analytics | Reply | volatile Table | Not all objects, but Volatile tables!Regards,Adeel |
239 | 01 Jun 2009 @ 07:30 PDT | Analytics | Reply | volatile Table | Let me rephrase what you described as follows:Suppose following:CT = Create TableCVT = Create Volatile TableT* = TimeT1: Session1 => CT => VT2 - DoneT2: Session1 => CVT => VT2 - ErrorT3... |
238 | 01 Jun 2009 @ 05:30 PDT | Analytics | Reply | volatile Table | Hello,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... |
237 | 01 Jun 2009 @ 03:07 PDT | Database | Reply | Teradata PI and SI restrictions | Well, 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... |
236 | 01 Jun 2009 @ 02:36 PDT | Database | Reply | Teradata PI and SI restrictions | Hello,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 ... |
235 | 26 May 2009 @ 05:05 PDT | UDA | Reply | Instr function in Oracle has to be replaced by Position Function | Hello,Following thread contains the answer of your question:http://www.teradata.com/teradataforum/Topic13579-1-1.aspx?Highlight=instrRegards,Adeel |
234 | 18 May 2009 @ 01:26 PDT | Database | Reply | Teradata SQL Assistant ( cross platform connection ) | http://www.teradata.com/teradataforum/Topic15465-1-1.aspxhttp://www.teradata.com/teradataforum/Topic15463-10-1.aspx |
233 | 18 May 2009 @ 01:24 PDT | Tools | Reply | Teradata 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 |
232 | 18 May 2009 @ 01:23 PDT | Connectivity | Reply | Teradata SQL Assistant ( cross platform connection ) | Please do not post same question in multiple forums sub-sections! |
231 | 18 May 2009 @ 06:04 PDT | Connectivity | Reply | how 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 (... |
230 | 18 May 2009 @ 05:45 PDT | Connectivity | Reply | how 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... |
229 | 18 May 2009 @ 04:28 PDT | Connectivity | Reply | How to use cursors in UDF | Hello,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... |
228 | 12 May 2009 @ 12:07 PDT | Training | Reply | new to Teradata | Hello,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... |
227 | 11 May 2009 @ 11:57 PDT | Database | Reply | Case | Hello,Can you please explain what exactly you need to do?Regards,Adeel |
226 | 11 May 2009 @ 11:55 PDT | Database | Reply | Version 12 | Hello,Following link contains the detailed answer of your question:http://www.teradata.com/teradataforum/FindPost13404.aspxRegards,Adeel |
225 | 11 May 2009 @ 04:57 PDT | Tools | Reply | Fastload utility | Hello,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... |
224 | 08 May 2009 @ 12:21 PDT | Database | Reply | For loop problem | Hello,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_... |