All forum activity

#DateUserForumTypeThreadPost
5971708 Sep 2016 @ 04:15 PDTODBCTeamConnectivityReplyConnectivity issue@atiliomedina The .genuine_TTU file has to be owned by root and have permission of 4111 Could you kindly try changing the owner to root, if not already root. Change the file permissi...
5971608 Sep 2016 @ 04:12 PDTfgrimmerTeradata StudioReplyGetting row countsWolfgang, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
5971508 Sep 2016 @ 04:11 PDTfgrimmerTeradata StudioReplyTeradata 15.1 Error when trying to execute queryVinoth, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
5971408 Sep 2016 @ 04:10 PDTfgrimmerTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsChristopher, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
5971308 Sep 2016 @ 04:09 PDTfgrimmerTeradata StudioReplyStudio Express severe keyboard lagSteven, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
5971208 Sep 2016 @ 04:08 PDTfgrimmerTeradata StudioReplyWhy is the first dynamic result set in a procedure is empty?Sharon, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
5971108 Sep 2016 @ 04:07 PDTfgrimmerTeradata StudioReplyTerdata Studio Express laggy on macJing, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
5971008 Sep 2016 @ 02:55 PDTFredToolsReplySQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter KeyWhich patch level of SQL Assistant? There was a fix related to quoted named parameters included in 15.0.0.4
5970908 Sep 2016 @ 12:19 PDT31_resuToolsReplySQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter KeyBump - No one has seen or heard of this?  Update, seems to random, some queires it not an issue, others it is. I have tried things like retype it, but also copy/pate into Notepad to strip off ...
5970808 Sep 2016 @ 12:08 PDTToddAWalterDatabaseReplyRules for Multi value compression 1. no MVC on PIs 2. Can have MVC on as many columns as desired, no such thing as too many columns. If there is a very large number of very large values, it is possible to exceed the total space li...
5970708 Sep 2016 @ 12:05 PDTteradatauser2DatabaseReplyRules for Multi value compression 1. Is MVC allowed on primary index ? - No this is not possible.  2. Having MVC on too many columns will create problem ? - No, the more columns you have compression on, the more savings you...
5970608 Sep 2016 @ 10:21 PDTDeepakjiDatabaseTopicRules for Multi value compression Can anyone help me on the below questions..   1. Is MVC allowed on primary index ? 2. Having MVC on too many columns will create problem ? 3.Is appliying compression on truncate and load t...
5970508 Sep 2016 @ 10:14 PDTDeepakjiDatabaseReplyCan we pass object as parameter in a macro ? Thanks Fred.. I was able to achieve through stored procedure.. thanks for your support
5970408 Sep 2016 @ 09:25 PDTindra91GeneralTopicExport LOB objects with size greater than 64KWe want to offload LOB objects from Teradata tables where  size is greater than 64K.I am trying to evaluate all the options at disposal here. Does FastExport utility support offloading...
5970308 Sep 2016 @ 08:27 PDTtbemelToolsReplyError: "The installation of shared ICU-32 bit appears to have failed. Do you want to continue?"Same issue here, thanks
5970208 Sep 2016 @ 07:59 PDTrob_watsonDatabaseTopicTO_NUMBER returns wrong valueHi, I'm trying to convert a series of hex values (stored as strings) to numbers ( BIGINT) using the TO_NUMBER function . A number of the results giivng the incorrect number SELECT TO_NUMBER( ...
5970108 Sep 2016 @ 07:19 PDTAtardecerR0j0DatabaseReplyCollapse one to many into one SQL query result row create multiset volatile table Task_Table ( Task_ID integer, Resource_ID integer )primary index( Task_ID ) on commit preserve rows; insert into Task_Table va...
5970008 Sep 2016 @ 06:47 PDTkirthiDatabaseReplyCollect Stats with insert statementMay be you can copy stats from source table if updated stats are already present in that table and you are loading entire records with out a where clause.  COLLECT STATS ON  Databas...
5969908 Sep 2016 @ 06:23 PDTreddro52ToolsReplyTeradata SQL Assistant - Multiple Answer Window Tiles MergeI'm having the same problem.  The Query window is tabbed, so that I can have multiple queries available.  I can't find a way to get the results presented in one window with tabs,...
5969808 Sep 2016 @ 05:12 PDTbadlishahConnectivityTopicFailed to start REST serviceHi, I'm a newbie. My team have installed REST and Tomcat. However, we found that REST service failed to start. We rebooted and during the reboot we could see that 'tdrestd.. FAILED'. S...
5969708 Sep 2016 @ 04:28 PDTSrinivas_teraDatabaseReplyCollect Stats with insert statementSTATS are not automatically refreshed, you need a third statement. When you create a table with no data and stats, the stats will be defined as per the original table with zero stats.
5969608 Sep 2016 @ 02:41 PDTsam_coderunner2ToolsTopicIncremental Data Load/CDC using Teradata UtilityHi, I'm new to Teradata, I would want to know if there is any utlity within Teradata which allows user to capture changed data from database. The identification of changed data should be done ...
5969508 Sep 2016 @ 02:36 PDTAlexiTeradata DebuggerTopicIdentity Column in Composite UPIDear All, Have a good day!!! Could you help to understand why Identity column in Teradata can not be included in composite UPI? Thanks.
5969408 Sep 2016 @ 12:11 PDTColinPrettyToolsReplyTPT Multiple JobVar filesI did forget to mention that I'm on 14 (soon to be upgrading to 15).  I'm guessing that means I can't do it as yet, so I'll hold fire until then. Thanks for the response Steve.
5969307 Sep 2016 @ 11:13 PDTmikemadrinanGeneralReplyWorking with XMLTABLE, problem extracting data where elements have no prefixes/namespacesOk, after some experimentation, I think I fixed the issue... As I've mentioned, the above code is just mocked code I prepared for the purpose of demonstrating my issue.  There is actually ...

Pages