298 | 22 Jun 2010 @ 09:14 PDT | Analytics | Reply | Dynamic DDL | Please don't post same question multiple times. |
297 | 22 Jun 2010 @ 09:11 PDT | Database | Reply | Dynamic DDL | Hi,
Please have a look at CREATE TABLE AS statement from the documentation .... that looks perfect solution for what scenario you have mentioned.
Regards,
MAC |
296 | 22 Jun 2010 @ 09:09 PDT | Database | Reply | improve peformance by using functions instead of coalesce | Hi,
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... |
295 | 16 Jun 2010 @ 09:15 PDT | Database | Reply | CASE function | Hi,
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;
... |
294 | 16 Jun 2010 @ 04:17 PDT | Extensibility | Reply | External Store procedure to read a local client file | The 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,... |
293 | 16 Jun 2010 @ 04:06 PDT | Marketing & CRM | Reply | I need a MACRO that will allow the User to define the table | Can you please provide more details what exactly you are trying to achieve? |
292 | 16 Jun 2010 @ 04:05 PDT | Marketing & CRM | Reply | C++ compiler | Teradata 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 |
291 | 16 Jun 2010 @ 04:00 PDT | Analytics | Reply | Need 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 |
290 | 16 Jun 2010 @ 03:45 PDT | Database | Reply | Capture the data while updating a table | Hi,
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 |
289 | 16 Jun 2010 @ 03:42 PDT | General | Reply | Problem with Extented Ascii data | Hi,
Can you please mention from which tool you are trying to read data?
Regards,
MAC |
288 | 05 Apr 2010 @ 12:48 PDT | UDA | Reply | Teradata - Oracle - Query Rewrite - Qualify & Rank | okay .... my bad! :) |
287 | 03 Apr 2010 @ 09:07 PDT | UDA | Reply | Teradata - Oracle - Query Rewrite - Qualify & Rank | Hi,
You don't have to do anything to above query .... as QUALIFY & RANK both work fine on Teradata.
HTH!
Regards,
MAC |
286 | 01 Apr 2010 @ 04:51 PDT | Database | Reply | Inserting space as value from a char column to varchar column | Hi,
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 (... |
285 | 01 Apr 2010 @ 04:31 PDT | Database | Reply | Pros and cons | Perhaps adding a bit more detail to points 3 & 4 would help! |
284 | 01 Apr 2010 @ 04:25 PDT | Database | Reply | Best 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... |
283 | 01 Apr 2010 @ 04:18 PDT | Database | Reply | Alternative to count(*) in Teradata | The 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... |
282 | 01 Apr 2010 @ 04:09 PDT | Database | Reply | Manual migration onto database | Hi,
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... |
281 | 01 Apr 2010 @ 12:39 PDT | Database | Reply | I'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
-... |
280 | 01 Apr 2010 @ 12:35 PDT | Database | Reply | Is 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 |
279 | 01 Apr 2010 @ 12:29 PDT | Third Party Software | Reply | Ab Initio ETL Training Online | As per my knowledge .... there is no training available online for AbInitio. |
278 | 01 Apr 2010 @ 12:28 PDT | Teradata Applications | Reply | Dynamic Cursors | http://forums.teradata.com/forum/analytics/how-to-fetch-rows-from-a-teradata-cursor-when-i-am-not-sure-about-no-of-columns |
277 | 01 Apr 2010 @ 12:25 PDT | Analytics | Reply | how to fetch rows from a teradata cursor when i am not sure about no of columns | Hi,
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... |
276 | 01 Apr 2010 @ 12:21 PDT | Database | Reply | Converting data and time to timestamp | Hi,
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... |
275 | 01 Apr 2010 @ 12:10 PDT | General | Reply | How to identify which BTEQ ran a particular Query | Hi,
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... |
274 | 31 Mar 2010 @ 11:59 PDT | General | Reply | Duplication when insert in teradata | Hi,
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! :)
... |