All comment activity

#DateUserWhereItemComment
686029 Jun 2016 @ 04:06 PDTteradatauser2DatabaseSecurity Administration - Accessing the Teradata Database Through a Middle-tierHi, I am trying to test few scenarious using my id as a proxy user, but i get below error: I ran - Grant connect through idw_bo_user to permanent "samir.singh" without role using dbc. i...
685929 Jun 2016 @ 01:29 PDThead8sToolsNew Teradata Studio Administration User ExperienceCouple of changes I'm not too thrilled about: - Drop & Row Count is no longer available on the shortcut menu in Query Development perspective - Data Source Explorer - Move Space is no lo...
685829 Jun 2016 @ 11:16 PDTrandy.dycus2ViewpointIntroduction to Viewpoint 15.11 MobileHi Craig, This looks just like what I have been hoping for - looks like we will need to upgrade Viewpoint, but what about the DBS version? We are still at 14.10 - will that be an issue?   ...
685729 Jun 2016 @ 11:03 PDTrandy.dycus2ToolsNew Teradata Studio Administration User ExperienceThanks again, Francine - you have been most helpful.
685629 Jun 2016 @ 09:24 PDTfgrimmerToolsNew Teradata Studio Administration User ExperienceRandy, I did a quick check on the RFC and the status is "WAIT", which I am not sure what that means. It doesn't look like much has been done since it was opened a while ago. It was op...
685529 Jun 2016 @ 03:04 PDTrandy.dycus2ToolsNew Teradata Studio Administration User ExperienceThank you!  Is there an easy way to know when this RFC has been implemented? I appreciate your quick responses, Randy
685428 Jun 2016 @ 10:23 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressSteven, Glad you found the answer! Cheers.
685328 Jun 2016 @ 09:51 PDTStevenSchmidToolsTransitioning from SQL Assistant to Studio Express "New Teradata Studio Administration User Experience" POST: Randy, I am seeing the statement fails with [3606 : 42000] Syntax error: Invalid SQL Statement when the comment comes befor...
685228 Jun 2016 @ 09:30 PDTStevenSchmidToolsTransitioning from SQL Assistant to Studio ExpressHi Francine I'm creating a fairly simple stored procedure in Studio.  When I compile it, if there are errors, it doesn't display the line numbers like SQLA does, so not easy to debug,...
685128 Jun 2016 @ 02:07 PDTfgrimmerToolsNew Teradata Studio Administration User ExperienceRandy, I am seeing the statement fails with [3606 : 42000] Syntax error: Invalid SQL Statement when the comment comes before the REPLACE PROCEDURE. I found a similar post on our Studio Forum and a...
685028 Jun 2016 @ 01:26 PDTrandy.dycus2ToolsNew Teradata Studio Administration User ExperienceLooks like I was given bad information - my apologies.  It doesn't lose the comments, it won't even produce the procedure with the comments before the REPLACE. That is still problemat...
684928 Jun 2016 @ 12:54 PDTrandy.dycus2ToolsNew Teradata Studio Administration User ExperienceHi Francine, We are still on 14.10, but using Studio 15.10.   The Show statement will give us the Comments, as below ....  but if I turn around and execute it within Studio, the comments...
684828 Jun 2016 @ 10:58 PDTfgrimmerToolsNew Teradata Studio Administration User ExperienceRandy, What version of Teradata are you using. Studio executes a SHOW command to get the DDL. In older versions of Teradata, the SHOW in some cases did not reflect the latest DDL.
684728 Jun 2016 @ 08:33 PDTJohannes VinkToolsStudio 15.11 Available for DownloadHi Francine, alt+s is what I was looking for! Working nice. I did indeed overlook this one. Thanks.
684628 Jun 2016 @ 08:27 PDTrandy.dycus2ToolsNew Teradata Studio Administration User ExperienceHi there, When doing a generate DDL, we have comments before the actual DDL.  If we change the procedure and do a replace using Studio, those comments are ignored, and we lose them.   I...
684527 Jun 2016 @ 04:41 PDTcarriecarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi Nazy,   I can't think of any reason there would be a value in collecting stats on rowID.   RowIDs are often used in single-table join indexes as a means for the database cod...
684427 Jun 2016 @ 06:38 PDTnazygholizadehcarrie's blogNew opportunities for statistics collection in Teradata 14.0Hi carrie, Is there a benefit in collecting stats on the ROWID column in a join index? For the first time today, we saw a recommendation from Stats Manager to collect stats on ROWID col...
684324 Jun 2016 @ 09:04 PDTcarriecarrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerAmit,   You are correct in your basic understanding of how dynamic virtual partitions work.   I also agree with you that using the dynamic sharing of resources between virtual part...
684223 Jun 2016 @ 01:26 PDTisharmaToolsStudio 15.11 Available for Downloadthe service name should look something like this according to your info: ncluster/queen.customer.local.WINDC1.CUSTOMER.LOCAL just a note - i believe the KDC needs to be entered in caps
684123 Jun 2016 @ 01:05 PDTsluebkeToolsStudio 15.11 Available for DownloadThanks Isharma!  Would the service look something like this: queen name: queen.customer.local KDC = windc1.customer.local Service=ncluster/queen.windc1 Thanks!
684023 Jun 2016 @ 01:04 PDTsluebkeToolsStudio 15.11 Available for DownloadThanks Isharma!  Would the service look something like this: queen name: queen.customer.local KDC = windc1.customer.local Service=ncluster/queen.windc1 Thanks!
683923 Jun 2016 @ 11:13 PDTfgrimmerAsterAster Database support in Teradata Studio Express 14.02@dharmabitk, Please post your question to the Aster Forum (http://forums.teradata.com/forum/aster).
683823 Jun 2016 @ 10:50 PDTfgrimmerToolsStudio 15.11 Available for Download@Johannes, There are shortcut keys for executing statements in the SQL Editor, such as Ctrk+Alt+X to Execute All (like SQLA Execute), Alt+X Execute Selected Text, F5 to Execute as Individual Statem...
683723 Jun 2016 @ 10:23 PDTsmdorvalConnectivityTeradata Connector for Hadoop now availableindra91, I would suggest waiting for the TDCH 1.5 release and using the FastExport within TDCH which will give you the best results. Best regards, Sean
683623 Jun 2016 @ 10:15 PDTdesai51carrie's blogHow Resources are Shared in the SLES 11 Priority SchedulerHi Carrie, I am trying to understand the pros and cons of Virtual Partitioning (VP), specifically Dynamic Virtual Partitioning.  We have a shared system where two sister companies sharing the...

Pages