648 | 08 Apr 2014 @ 11:21 PDT | Database | Reply | Help me to get the backup of ONLY DBC tables DDL (Not data). | As suggested by Qaisar, in case of disaster you wil definitely require alot more than just DDLs.
Also, what kind of a disaster are we preventing here .... can we take some pre-emptive meas... |
647 | 08 Apr 2014 @ 11:19 PDT | Database | Reply | Key (Important) tables in DBC database | You can use the tables mentioned by Dave to know whats happening in the system and can surely find the areas that are being used frequently hence can put focused efforts on them to optimize the sys... |
646 | 08 Apr 2014 @ 11:15 PDT | Database | Reply | MERGE INTO and CONCATENATION | Increase the data-type of col2 in target table. It should resolve the issue.
|
645 | 08 Apr 2014 @ 11:12 PDT | Database | Reply | unable to download vmware teradata express | What exactly do you mean by 'deactivate mode'?
Downloads are available at following link:
http://downloads.teradata.com/download/database/teradata-express/vmware
|
644 | 08 Apr 2014 @ 11:10 PDT | Database | Reply | Upgrade TD14.10 and Reserved Words | How many tables/scripts are there we are talking about?
Also is there any ETL/BI tool being used which might have an impact?
Is the solution in production?
Which current ... |
643 | 08 Apr 2014 @ 11:06 PDT | Training | Reply | Need training in teradata | Topic moved to Training section.
|
642 | 08 Apr 2014 @ 11:04 PDT | Database | Reply | Error handling when inserting records | Please have a look at Jimm's reply on following link:
http://forums.teradata.com/forum/database/sending-email-from-procedure
And rgs's reply on:
http://forums.ter... |
641 | 26 Feb 2014 @ 09:17 PST | Database | Reply | Target row updated by MUltiple source rows error | You can find the duplicates by:
SELECT <primary index column(s)>, count(*) FROM <Table Name> GROUP BY <primary index column(s)> HAVING COUNT(*) > 1
|
640 | 26 Feb 2014 @ 04:35 PST | Tools | Reply | TTU 13.10 | Utilities are backward compatible .... but in case you are facing any particular issue, please dont hesitate to share the error with details.
|
639 | 26 Feb 2014 @ 04:34 PST | Database | Reply | Query Help | Can you share DDLs, with data and actual scenario and functionality you wish to achieve?
From what it seems .... it should just be a simple OUTER JOIN query.
|
638 | 26 Feb 2014 @ 04:31 PST | Database | Reply | Query Help | Moving to the correct sub-forum i.e. Database.
|
637 | 25 Feb 2014 @ 09:42 PST | Database | Reply | SQL to generate a column name list | True, just one enhancement ....
show select * from <ViewName>-- DDLs of [all the underlying] base table(s)/view(s) in a view
|
636 | 25 Feb 2014 @ 09:34 PST | Database | Reply | Update SQL query is taking long time to execute | You need to enable DBQL first .... check with yout DBA if it is enabled, and then he should be able to give you that report.
Whats the situation with statistics collection? And how busy is... |
635 | 25 Feb 2014 @ 09:30 PST | Database | Reply | SQL Issue - Qualify partition by issue | What you are doing in your code is .... you are casting ACCOUNTID in select for it to be DECIMAL .... but you are not converting is to DECIMAL in your PARTITION BY statement. Hence you will get bot... |
634 | 25 Feb 2014 @ 09:28 PST | General | Reply | Migrate Oracle UDF to Teradata UDF | Which TD version you are using and what is the purpose of those UDFs? Are they generic ones, or completely customized logic?
You might need to make some changes, so you need to have a good... |
633 | 25 Feb 2014 @ 09:26 PST | General | Reply | TDE 14.10.00.02 SLES 11 for VMware | Yes, working fine for me as well. Can you try and re-download?
|
632 | 24 Feb 2014 @ 11:56 PST | Database | Reply | Perm Space and Spool space | You can get the rough estimate by using: (number of rows x (sum of bytes taken of all fields)).
|
631 | 24 Feb 2014 @ 09:41 PST | General | Reply | TDE 14.10.00.02 SLES 11 for VMware | I have version 'TDExpress14.0.3_Sles10_4GB' .... it works just fine. I will try to download 40GB version and check if it has some issue.
Meanwhile, can you continue your work on 4G... |
630 | 24 Feb 2014 @ 09:39 PST | Database | Reply | Stored Procedures and I/O | It is a good idea to post your code that is causing an error .... along with the error you are getting for a quick fix for your help.
|
629 | 24 Feb 2014 @ 09:38 PST | Database | Reply | Keep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsert | I think there is some missing information .... can you share the whole script you use for creating-populating-deleting-recreating/repopulating data?
IDENTITY column never generates duplica... |
628 | 24 Feb 2014 @ 09:36 PST | Database | Reply | Stored Procedures and I/O | You can code it in SQL Assistant just fine .... for the correct syntax you can have a look at my last post on following thread:
http://forums.teradata.com/forum/database/date-as-integer#co... |
627 | 24 Feb 2014 @ 07:11 PST | Database | Reply | Date as Integer | You dont need to modify it, It will work as-is.
Following is a template SP:
REPLACE PROCEDURE <Database Name>.<Stored-Procedure Name>
(
)
BEGIN
DECLARE MySQLC... |
626 | 24 Feb 2014 @ 07:06 PST | General | Reply | TDE 14.10.00.02 SLES 11 for VMware | Do you have VM Player or Workstation?
|
625 | 24 Feb 2014 @ 07:05 PST | General | Reply | Teradata Express for Windows | If you have older link to download Teradata 13 Express, try that .... it may still work.
|
624 | 24 Feb 2014 @ 05:00 PST | Database | Reply | Filtering records that have overlapping dates | What exactly you mean by 'partitions'?
Also, can you give a sample data and expected result?
|