#DateForumTypeThreadPost
64808 Apr 2014 @ 11:21 PDTDatabaseReplyHelp 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...
64708 Apr 2014 @ 11:19 PDTDatabaseReplyKey (Important) tables in DBC databaseYou 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...
64608 Apr 2014 @ 11:15 PDTDatabaseReplyMERGE INTO and CONCATENATIONIncrease the data-type of col2 in target table.  It should resolve the issue.
64508 Apr 2014 @ 11:12 PDTDatabaseReplyunable to download vmware teradata expressWhat exactly do you mean by 'deactivate mode'?   Downloads are available at following link:   http://downloads.teradata.com/download/database/teradata-express/vmware
64408 Apr 2014 @ 11:10 PDTDatabaseReplyUpgrade TD14.10 and Reserved WordsHow 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 ...
64308 Apr 2014 @ 11:06 PDTTrainingReplyNeed training in teradataTopic moved to Training section.
64208 Apr 2014 @ 11:04 PDTDatabaseReplyError handling when inserting recordsPlease 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...
64126 Feb 2014 @ 09:17 PSTDatabaseReplyTarget row updated by MUltiple source rows errorYou can find the duplicates by:   SELECT <primary index column(s)>, count(*) FROM <Table Name> GROUP BY <primary index column(s)> HAVING COUNT(*) > 1
64026 Feb 2014 @ 04:35 PSTToolsReplyTTU 13.10Utilities are backward compatible .... but in case you are facing any particular issue, please dont hesitate to share the error with details.
63926 Feb 2014 @ 04:34 PSTDatabaseReplyQuery HelpCan 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.
63826 Feb 2014 @ 04:31 PSTDatabaseReplyQuery HelpMoving to the correct sub-forum i.e. Database.
63725 Feb 2014 @ 09:42 PSTDatabaseReplySQL to generate a column name listTrue, just one enhancement ....   show select * from  <ViewName>-- DDLs of [all the underlying] base table(s)/view(s) in a view
63625 Feb 2014 @ 09:34 PSTDatabaseReplyUpdate SQL query is taking long time to executeYou 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...
63525 Feb 2014 @ 09:30 PSTDatabaseReplySQL Issue - Qualify partition by issueWhat 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...
63425 Feb 2014 @ 09:28 PSTGeneralReplyMigrate Oracle UDF to Teradata UDFWhich 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...
63325 Feb 2014 @ 09:26 PSTGeneralReplyTDE 14.10.00.02 SLES 11 for VMwareYes, working fine for me as well. Can you try and re-download?
63224 Feb 2014 @ 11:56 PSTDatabaseReplyPerm Space and Spool space You can get the rough estimate by using: (number of rows x (sum of bytes taken of all fields)).
63124 Feb 2014 @ 09:41 PSTGeneralReplyTDE 14.10.00.02 SLES 11 for VMwareI 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...
63024 Feb 2014 @ 09:39 PSTDatabaseReplyStored Procedures and I/OIt 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.
62924 Feb 2014 @ 09:38 PSTDatabaseReplyKeep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsertI 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...
62824 Feb 2014 @ 09:36 PSTDatabaseReplyStored Procedures and I/OYou 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...
62724 Feb 2014 @ 07:11 PSTDatabaseReplyDate as IntegerYou 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...
62624 Feb 2014 @ 07:06 PSTGeneralReplyTDE 14.10.00.02 SLES 11 for VMwareDo you have VM Player or Workstation?
62524 Feb 2014 @ 07:05 PSTGeneralReplyTeradata Express for WindowsIf you have older link to download Teradata 13 Express, try that .... it may still work.
62424 Feb 2014 @ 05:00 PSTDatabaseReplyFiltering records that have overlapping datesWhat exactly you mean by 'partitions'?   Also, can you give a sample data and expected result?

Pages