All comment activity

#DateUserWhereItemComment
541120 Dec 2014 @ 06:44 PSTFei JuToolsTeradata Studio ExpressI try to user Teradat Studio Express to run sql on aster ( VM machine) . I can edit data in the table, but can not run SQL . The error message is java.lang.nullpointerexception. How can I deal with...
541020 Dec 2014 @ 09:57 PSTprabhakarank7ToolsTeradata Studio products - choosing the right client toolI need to practice Teradata SQL. Never worked on this before. I have installed Teradata Studio Express 15.00.02.00 for Windows. I am not sure if I need to install any other supporting softwares alo...
540919 Dec 2014 @ 07:37 PSTWoodyTeradata Performance ConsiderationsPerformance Data Collection Recommendations for Major UpgradesThere is a table that PDCR maintains which contains this information.  Look in your PDCRINFO database for it.  Or, you can contact the team that installed PDCR for you for more specifics.
540819 Dec 2014 @ 03:12 PSTraulbenetToolsTeradata Studio ExpressThank you Francine and Merry Christmas!
540718 Dec 2014 @ 04:41 PSTcarriecarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadRoberto,   There is no "default"  workload for just parsing.   Parsing will happen at the same workload that the session's logon uses.   Depending on t...
540618 Dec 2014 @ 02:42 PSTdins2k2Teradata Performance ConsiderationsPerformance Data Collection Recommendations for Major UpgradesHi,   How can I see the history of database space using diskspace?  I want to see last month's database size of databases in the system using PDCR. Please shed some light on this. ...
540518 Dec 2014 @ 02:39 PSTPaul LaPointeUDAWorking with Identity Columns and Unity Director and LoaderHi KS, Your index create is failing because you are trying to use an identity column in a composite index, which isn't allowed. You might try the seconday index without Identity column in it....
540418 Dec 2014 @ 05:03 PSTKS2014UDAWorking with Identity Columns and Unity Director and Loader Hi Paul,   I am trying to execute below code but getting error in second code i.e. at the time of creation index.   We need unique sequence number in the table and crea...
540318 Dec 2014 @ 03:49 PSTbutchecGeneralWorking with Stored Procedures in Unity DirectorHi Paul the effect of RESIGNAL has me confused and I am wondering if this is going to be an issue.  From your example, my understanding of the benefit of adding RESIGNAL to SP error handling...
540217 Dec 2014 @ 02:02 PSTdnoethÜber SQLNew StatsInfo query for TD14Hi Samir, yep, this is correct :)
540117 Dec 2014 @ 10:08 PSTfgrimmerToolsTeradata Studio ExpressRaul, I am afraid I am not the right person to answer your question. I know that an EXPLAIN will tell you more information about your query that can help with understanding its effeciency. But I wo...
540017 Dec 2014 @ 04:48 PSTraulbenetToolsTeradata Studio ExpressHello Francine, I am not sure if this is the right forum for the following question but since you were so helpful the last time (thanks for your answer by the way!) I will take my chances :) I hav...
539917 Dec 2014 @ 01:53 PSTteradatauser2Über SQLNew StatsInfo query for TD14Hi Diether,   I think i got it. I saw your post above regarding this. I just need to check the presence of that databasename and tablename in view dbc.StatsV. This view contains all the colu...
539816 Dec 2014 @ 02:08 PSTrrundocarrie's blogA Closer Look at How to Set up a Parsing-Only WorkloadHi Carrie, I used the Parsing Workload you describe at one of my customers who is running TD14.10/SLES11 with VP15. This workload is working perfectly. But, if I do not use this WD all ...
539716 Dec 2014 @ 10:00 PSTteradatauser2Über SQLNew StatsInfo query for TD14Basically i want to find tables having stats on them - single column, index or multicolumn. below query gives me the o/p , but i want to know if there is any view like in 13.10 (as we used in above...
539616 Dec 2014 @ 09:19 PSTteradatauser2Über SQLNew StatsInfo query for TD14 Hi Diether,   We have migrated to TD 14.10 few days back. Previously we had TD 13.10. In our collect stats architecure, we have the below query that fails now saying that DBC.M...
539516 Dec 2014 @ 01:36 PSTteradatauser2ViewpointWhat's New With Viewpoint 15.00 Shared Pagesthanks for the information wdarling. Just an update, for my above question. when i go to admin section in portlets tab in viewpoint for dba role as you suggested, the shared pages is enabled and as...
539415 Dec 2014 @ 03:18 PSTCliff LUDANew Teradata Unity Data Mover 15.00 AvailableData Mover does not land any data to disk so the data being extracted from the source system must always be immediately loaded to the target system. If the target system is down or unavailable, the...
539315 Dec 2014 @ 02:01 PSTakd2k6UDANew Teradata Unity Data Mover 15.00 AvailableCan datamover unload to intermediate file also with it's dml for future use?or it just can do on the fly unload and load?
539211 Dec 2014 @ 07:30 PSTPaul LaPointeUDAWorking with Identity Columns and Unity Director and LoaderHi Ulrich, Yes, you are exactly correct - the UUID UDF isn't suitable if you are issuing a single request like an insert-select. Unity Director/Loader will sets the current time for the reques...
539110 Dec 2014 @ 01:37 PSTulrichUDAWorking with Identity Columns and Unity Director and LoaderHi Paul, I have to admit that I missed the possible impact of the trigger and the current_timestamp when you load the data with TPUMP or TPT Stream. But if you use the szenario for insert/selects...
539010 Dec 2014 @ 07:10 PSTPaul LaPointeUDAWorking with Identity Columns and Unity Director and LoaderUlrich, I think you may have taken the math slightly out of context - the entire key consists of the timestamp and the random number, not just the random number and is intended to provide a surroga...
538910 Dec 2014 @ 04:47 PSTulrichUDAWorking with Identity Columns and Unity Director and LoaderPaul, the syslib.UUID() is clearly not usable as a UUID generator. The number of synonyms is fare to high. With select id, count(0) from ( select calendar_date, syslib.UUID() as id...
538809 Dec 2014 @ 03:32 PSTdbc1012ConnectivityAccess External Data - A Table UDFDue to technical complexities, the top level article had to be published before the two sub articles. I've now published the sub-articles with "the stuff". Apologies for the delay in ...
538709 Dec 2014 @ 11:42 PSTMikeDempseyToolsWhat's new in Teradata SQL Assistant 15.0I should add a caveat to the response above. Even with 15.0.0.4 you will not be able to use ?B or ?C as named parameters unless they are enclosed in quotes. The unquoted values ?B and ?C are alwa...

Pages