|59720||08 Sep 2016 @ 04:15 PDT||ODBCTeam||Connectivity||Reply||Connectivity 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... |
|59719||08 Sep 2016 @ 04:12 PDT||fgrimmer||Teradata Studio||Reply||Getting row counts||Wolfgang, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
|59718||08 Sep 2016 @ 04:11 PDT||fgrimmer||Teradata Studio||Reply||Teradata 15.1 Error when trying to execute query||Vinoth, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
|59717||08 Sep 2016 @ 04:10 PDT||fgrimmer||Teradata Studio||Reply||Teradata Studio 15.10.01.01 on Mac OS X -- Hangs||Christopher, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
|59716||08 Sep 2016 @ 04:09 PDT||fgrimmer||Teradata Studio||Reply||Studio Express severe keyboard lag||Steven, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
|59715||08 Sep 2016 @ 04:08 PDT||fgrimmer||Teradata Studio||Reply||Why 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.
|59714||08 Sep 2016 @ 04:07 PDT||fgrimmer||Teradata Studio||Reply||Terdata Studio Express laggy on mac||Jing, Studio 15.12 will be available after the Teradata Partners conference next week. Sorry for the delay.
|59713||08 Sep 2016 @ 02:55 PDT||Fred||Tools||Reply||SQL Assistant 15.00 TD 220.127.116.11 Doesn't Properly read first Parameter Key||Which patch level of SQL Assistant? There was a fix related to quoted named parameters included in 18.104.22.168
|59712||08 Sep 2016 @ 12:19 PDT||31_resu||Tools||Reply||SQL Assistant 15.00 TD 22.214.171.124 Doesn't Properly read first Parameter Key||Bump - 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 ... |
|59711||08 Sep 2016 @ 12:08 PDT||ToddAWalter||Database||Reply||Rules 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... |
|59710||08 Sep 2016 @ 12:05 PDT||teradatauser2||Database||Reply||Rules 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... |
|59709||08 Sep 2016 @ 10:21 PDT||Deepakji||Database||Topic||Rules 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... |
|59708||08 Sep 2016 @ 10:14 PDT||Deepakji||Database||Reply||Can we pass object as parameter in a macro ? ||Thanks Fred.. I was able to achieve through stored procedure.. thanks for your support
|59707||08 Sep 2016 @ 09:25 PDT||indra91||General||Topic||Export LOB objects with size greater than 64K||We 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... |
|59706||08 Sep 2016 @ 08:27 PDT||tbemel||Tools||Reply||Error: "The installation of shared ICU-32 bit appears to have failed. Do you want to continue?"||Same issue here, thanks
|59705||08 Sep 2016 @ 07:59 PDT||rob_watson||Database||Topic||TO_NUMBER returns wrong value||Hi,
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( ... |
|59704||08 Sep 2016 @ 07:19 PDT||AtardecerR0j0||Database||Reply||Collapse one to many into one SQL query result row||
create multiset volatile table Task_Table
)primary index( Task_ID )
on commit preserve rows;
insert into Task_Table va... |
|59703||08 Sep 2016 @ 06:47 PDT||kirthi||Database||Reply||Collect Stats with insert statement||May 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... |
|59702||08 Sep 2016 @ 06:23 PDT||reddro52||Tools||Reply||Teradata SQL Assistant - Multiple Answer Window Tiles Merge||I'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,... |
|59701||08 Sep 2016 @ 05:12 PDT||badlishah||Connectivity||Topic||Failed to start REST service||Hi,
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... |
|59700||08 Sep 2016 @ 04:28 PDT||Srinivas_tera||Database||Reply||Collect Stats with insert statement||STATS 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.
|59699||08 Sep 2016 @ 02:41 PDT||sam_coderunner2||Tools||Topic||Incremental Data Load/CDC using Teradata Utility||Hi,
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 ... |
|59698||08 Sep 2016 @ 02:36 PDT||Alexi||Teradata Debugger||Topic||Identity Column in Composite UPI||Dear All,
Have a good day!!!
Could you help to understand why Identity column in Teradata can not be included in composite UPI?
|59697||08 Sep 2016 @ 12:11 PDT||ColinPretty||Tools||Reply||TPT Multiple JobVar files||I 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.
|59696||07 Sep 2016 @ 11:13 PDT||mikemadrinan||General||Reply||Working with XMLTABLE, problem extracting data where elements have no prefixes/namespaces||Ok, 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 ... |