#DateForumTypeThreadPost
29822 Jun 2010 @ 09:14 PDTAnalyticsReplyDynamic DDLPlease don't post same question multiple times.
29722 Jun 2010 @ 09:11 PDTDatabaseReplyDynamic DDLHi, Please have a look at CREATE TABLE AS statement from the documentation .... that looks perfect solution for what scenario you have mentioned. Regards, MAC
29622 Jun 2010 @ 09:09 PDTDatabaseReplyimprove peformance by using functions instead of coalesceHi, Built-in or standard functions always work best as compared to user defined function .... so am afraid you have limited options. Perhaps, what can be done is to devise a strategy to handl...
29516 Jun 2010 @ 09:15 PDTDatabaseReplyCASE functionHi, In the case of CHAR it will do exactly the same .... and yes it will work just fine with TRIM .... example as follows: CREATE VOLATILE TABLE Tab1 (Col1 CHAR(24)) ON COMMIT PRESERVE ROWS; ...
29416 Jun 2010 @ 04:17 PDTExtensibilityReplyExternal Store procedure to read a local client fileThe process of "call parseFile('filename');" can be easily achieved using a combination of UDFs and SPs. UDFs for reading data from file and SPs for using that data and INSERTs/UPDATEs. Regards,...
29316 Jun 2010 @ 04:06 PDTMarketing & CRMReplyI need a MACRO that will allow the User to define the tableCan you please provide more details what exactly you are trying to achieve?
29216 Jun 2010 @ 04:05 PDTMarketing & CRMReplyC++ compilerTeradata requires C++ compiler .... the question of "what compiler" depends on the answer of "what OS". You can get the list of supported OS and C++ compiler from help/support. Regards, MAC
29116 Jun 2010 @ 04:00 PDTAnalyticsReplyNeed help on logic!Hi, What is "Tasks" column in second table? Can you provide 1 detailed example of what are the inputs and what exactly are you trying to achieve? Regards, MAC
29016 Jun 2010 @ 03:45 PDTDatabaseReplyCapture the data while updating a tableHi, Triggers would be your best bet .... but as you mentioned you are not allowed to use them .... can you share some UPDATE statements to clear the overall picture? Regards, MAC
28916 Jun 2010 @ 03:42 PDTGeneralReplyProblem with Extented Ascii dataHi, Can you please mention from which tool you are trying to read data? Regards, MAC
28805 Apr 2010 @ 12:48 PDTUDAReplyTeradata - Oracle - Query Rewrite - Qualify & Rankokay .... my bad! :)
28703 Apr 2010 @ 09:07 PDTUDAReplyTeradata - Oracle - Query Rewrite - Qualify & RankHi, You don't have to do anything to above query .... as QUALIFY & RANK both work fine on Teradata. HTH! Regards, MAC
28601 Apr 2010 @ 04:51 PDTDatabaseReplyInserting space as value from a char column to varchar columnHi, Following is a sample SQL: CREATE VOLATILE TABLE Table1(Col1 CHAR(10)) ON COMMIT PRESERVE ROWS; CREATE VOLATILE TABLE Table2(Col1 VARCHAR(10)) ON COMMIT PRESERVE ROWS; INSERT Table1 (...
28501 Apr 2010 @ 04:31 PDTDatabaseReplyPros and consPerhaps adding a bit more detail to points 3 & 4 would help!
28401 Apr 2010 @ 04:25 PDTDatabaseReplyBest way to compare contents of two tables?Hi, I couldn't understand exactly what you are trying to do .... match the columns and data-types .... or match data for given tables perhaps to mark rows for insert, update and/or delete. If...
28301 Apr 2010 @ 04:18 PDTDatabaseReplyAlternative to count(*) in TeradataThe storing of row-count in SQL Server is totally different .... whenever the rows are inserted or deleted it maintains the count in its system-tables. This makes additional work to be done i.e. mo...
28201 Apr 2010 @ 04:09 PDTDatabaseReplyManual migration onto databaseHi, From what i have understood .... IF you need to transfer huge amount of data from MySQL to Teradata, what you can do is to dump data in text-file and then load it in Teradata using TD Utilit...
28101 Apr 2010 @ 12:39 PDTDatabaseReplyI'm a learner of teradata. And could you advise me How to study teradata?Hi, One approach can be as follows: - Install TD express - It will copy TD documentation as well .... start reading it and trying out things - Put time in understanding TD's architecture -...
28001 Apr 2010 @ 12:35 PDTDatabaseReplyIs there any automated tool to compress the data in Teradata..Hi, So far .... we don't have any such tool in Teradata. Though .... there are third-party tools available for this. Regards, MAC
27901 Apr 2010 @ 12:29 PDTThird Party SoftwareReplyAb Initio ETL Training OnlineAs per my knowledge .... there is no training available online for AbInitio.
27801 Apr 2010 @ 12:28 PDTTeradata ApplicationsReplyDynamic Cursors http://forums.teradata.com/forum/analytics/how-to-fetch-rows-from-a-teradata-cursor-when-i-am-not-sure-about-no-of-columns
27701 Apr 2010 @ 12:25 PDTAnalyticsReplyhow to fetch rows from a teradata cursor when i am not sure about no of columnsHi, In such scenario, what you can do is .... count the columns, can be done my counting ',' between SELECT and FROM, before executing the query. You will also have to take care about the dat...
27601 Apr 2010 @ 12:21 PDTDatabaseReplyConverting data and time to timestampHi, The format of the date/time don't usually change the date/time value .... please verify if your server's date is different than your client's date. Following query may be used to verify t...
27501 Apr 2010 @ 12:10 PDTGeneralReplyHow to identify which BTEQ ran a particular QueryHi, I doubt if there is any built-in solution for this .... but what you can do is pretty much possible .... couple methods can be: - Have a log table (columns: Accessed_Table_Name, BTEQ_Name...
27431 Mar 2010 @ 11:59 PDTGeneralReplyDuplication when insert in teradataHi, It is a DB error .... can you share the DDL of the table you are trying to insert data into? Additionally, a small suggestion .... its easier to understand code if somewhat aligned! :) ...

Pages