#DateForumTypeThreadPost
10910 Dec 2010 @ 07:26 PSTDatabaseReplyIs there a limit to the number of arguments in an "IN" statement?Teradata has made some improvements to IN list processing but the query must meet certain criteria in order for it to be used. (I believe there is an Orange Book available on the subject.) The form...
10810 Dec 2010 @ 06:41 PSTDatabaseReplyTeradata Database: Selected non-aggregate values must be part of the associate group 3504Max, You added a new column to your SELECT list but did not include it in your GROUP BY clause. If you add cvDHS_Provider_CDC_Assignment.Provider_Related_Flag to the GROUP BY clause you should b...
10704 Nov 2010 @ 05:53 PDTTrainingReplyTeradata 12 CertificationThere will be a certifcation study guide available for purchase on Amazon very soon. It was available for purchase at the 2010 Partner's Conference. (http://twitter.com/teradata/statuses/29392690491)
10602 Nov 2010 @ 06:45 PDTDatabaseReplyTeradata V13 and CommentsHave you considered using Query Bands for this? The data in the query band will be retained in DBQL and can be submitted per transaction. SET QUERY_BAND ='proj=ProjectName;report=Q1Analysis;' FO...
10501 Nov 2010 @ 08:36 PDTDatabaseReplyHow to get the create script of procedure or macro without knowledge about object type?(1) Using BTEQ take export the output of that SQL statement to a text file. (2) Close the export (3) Using the RUN command in BTEQ to run the file you just generated. You can also insert comma...
10401 Nov 2010 @ 08:14 PDTDatabaseReplyNumeric overflow....2616Dieter, It's surprising with the introduction of BIGINT that the default data type returned in Teradata mode was not changed. (Of course it would wreak havoc with MS Office products that do not ...
10326 Oct 2010 @ 11:49 PDTGeneralReplydays since Jan 1 ,4712 BC in TeradataGood information Carlos. (Thank you Google Translator. ;) )
10226 Oct 2010 @ 07:43 PDTDatabaseReplyHow to copy a table with it table comment and column comment ?After copying the table with or with out data you can write an SQL statement against DBC.Tables and DBC.Columns to pull the Comment and construct the COMMENT TABLE or COMMENT COLUMN statements to b...
10125 Oct 2010 @ 05:03 PDTGeneralReplydays since Jan 1 ,4712 BC in TeradataValid range of dates in Teradata is from 0001-01-01 through 9999-12-31. The same applies for timestamps as well. To work with Julian dates you may need to build a physical table or UDF and use a ch...
10022 Oct 2010 @ 09:23 PDTDatabaseReplyMultiset and UPI in GTT.Follow the discussion here and pay particular attention to Todd Walter's comments: http://www.teradataforum.com/teradata/20060426_145529.htm
9922 Oct 2010 @ 09:11 PDTGeneralReplyDifferences between V2R6 and Teradata 12.0Check out the answers in this Dev Exchange question: http://forums.teradata.com/forum/general/diff-between-tdv2r5-and-td12 You will find links to publicly accessible Teradata Release Summaries.
9822 Oct 2010 @ 08:34 PDTViewpointReplyIE 6.x usage of ViewpointAt my previous client, as an IT employee you were allowed to install a second browser such as Firefox but the client team at the risk of losing support for any customizations made to the client ima...
9721 Oct 2010 @ 06:12 PDTDatabaseReplyBackup All database objects only without data....From the Database Administration manual: "A dictionary table archive contains all table, view, macro and trigger definitions in the database, and dictionary entries for stored procedures and us...
9620 Oct 2010 @ 10:43 PDTViewpointReplyIE 6.x usage of ViewpointGary, The previous client I worked with in the public sector was still at IE6 on their most recent client image that was rolled out in 2009/2010. I'd suggest including support for Chrome and Saf...
9520 Oct 2010 @ 09:36 PDTGeneralReplyETL jobs hangingA few questions to help get a better understanding of the situation and may to spark some more conversation: How many iterations of this update statement are being run as part of the ETL job? A...
9420 Oct 2010 @ 06:51 PDTGeneralReplydiff between tdv2r5 and td12Start by reviewing the Release Summaries: V2R6.2 - http://www.info.teradata.com/edownload.cfm?itemid=062430003 Teradata 12 - http://www.info.teradata.com/edownload.cfm?itemid=072600018 You m...
9315 Oct 2010 @ 09:41 PDTUDAReplyTASM BehaviourFirst thing that comes to mind reading over this is that either the tactical workload is not truly tactical in nature: (1) 1 or 2 AMP operation using PI or USI. (2) Some AMP operation joining on ...
9215 Oct 2010 @ 09:29 PDTUDAReplyConverting Hot Standby Node to Active NodeIsn't the intended purpose of a HSN for high availability only? It is not intended to behave like a mainframe where you can "purchase" additional MIPS periodically to help you deal with a performan...
9115 Oct 2010 @ 09:19 PDTDatabaseReplywant to Install TD 13 Express on OpenSuse PCThe only way that I am aware of accomplishing what you want is to us VMware Player or VMware Workstation for Linux. This will allow you to run it as a virtual appliance on your laptop. VMware Playe...
9015 Oct 2010 @ 09:14 PDTDatabaseReplyBackup Terminated in the Middle of the way..It depends on if you enabled checkpoints for the archive in question. If not when you restart the archive it will start from the beginning. See Chapter 4 of the Archive/Recovery Utility Reference f...
8915 Oct 2010 @ 09:08 PDTDatabaseReplyWhere are Stored Procedures stored ?How much space are you allocating for your stored procedure database that you are consuming all of the space on one or two AMPS for the storage of the stored procedure? (Just curious)
8815 Oct 2010 @ 09:06 PDTDatabaseReplyAbout getting better quality on databasesHave you considered the offerings from either Pentaho or Talend? While you are considering a technological solution to your data quality / integration gap keep in mind that the people and proce...
8715 Oct 2010 @ 08:55 PDTGeneralReplyRemoving SQL Assistant pop-up when you run queriesJames, If you go to the Tools Menu -> Options and select the Query Tab you will find a check box labeled: Prompt for a note before running any query. Remove the check and the problem should go a...
8613 Oct 2010 @ 10:22 PDTToolsReplyNotePad++, a GPL replacement to UltraEdit and TextPad@UM - You will need to place (or merge) the userDefineLang.xml in %APPDATA%\Notepad++. I made the mistake of placing it in C:\Program Files\Notepad++ and it wouldn't work. I found %APPDATA%\Not...
8513 Oct 2010 @ 06:42 PDTToolsReplyUpdates for Express?Teradata just released an update for the 40GB VMWare TD Express 12 bringing it to release 12.00.03.14. Not sure if this means an update for the VMWare edition of TD Express 13 is imminent though.

Pages