59717 | 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... |
59716 | 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.
|
59715 | 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.
|
59714 | 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.
|
59713 | 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.
|
59712 | 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.
|
59711 | 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.
|
59710 | 08 Sep 2016 @ 02:55 PDT | Fred | Tools | Reply | SQL Assistant 15.00 TD 14.11.0.1 Doesn't Properly read first Parameter Key | Which patch level of SQL Assistant? There was a fix related to quoted named parameters included in 15.0.0.4
|
59709 | 08 Sep 2016 @ 12:19 PDT | 31_resu | Tools | Reply | SQL Assistant 15.00 TD 14.11.0.1 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 ... |
59708 | 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... |
59707 | 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... |
59706 | 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... |
59705 | 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
|
59704 | 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... |
59703 | 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
|
59702 | 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( ... |
59701 | 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
(
Task_ID integer,
Resource_ID integer
)primary index( Task_ID )
on commit preserve rows;
insert into Task_Table va... |
59700 | 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... |
59699 | 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,... |
59698 | 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... |
59697 | 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.
|
59696 | 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 ... |
59695 | 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?
Thanks.
|
59694 | 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.
|
59693 | 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 ... |