| 59642 | 05 Sep 2016 @ 01:28 PDT | jingguo | Teradata Studio | Reply | Terdata Studio Express laggy on mac | I found something else, if the "SQL Editor" gets laggy, I can create a "New SQL Editor" without closing the teradata studio express and the new "SQL Editor" is Not lag... |
| 59641 | 04 Sep 2016 @ 11:48 PDT | jingguo | Teradata Studio | Reply | Terdata Studio Express laggy on mac | when typing is very slow, if I run the statment, it could tale up to 10 seconds not showing any thing at the right bottom. it should show something like "TD: select * from..."
|
| 59640 | 04 Sep 2016 @ 11:39 PDT | Soumyatg | Database | Reply | Merge into operation | Thanks Saeed and Carlos for the clarification. I was comparing an insert against a merge into and it appeared that while CPUTime for Merge(with only when not macthed clause) was less, the... |
| 59639 | 04 Sep 2016 @ 10:57 PDT | jingguo | Teradata Studio | Reply | Terdata Studio Express laggy on mac | If I close the teradata studio express and open it again, the laggy will disappear.
|
| 59638 | 04 Sep 2016 @ 10:05 PDT | jingguo | Teradata Studio | Reply | Terdata Studio Express laggy on mac | I installed multiple java on my mac, but the JAVA panel shows only 1.8, JAVA_HOME is setting to 1.8 and below command shows jave version is 1.8.
java -version
java version "1.8.0_101"... |
| 59637 | 04 Sep 2016 @ 10:03 PDT | jingguo | Teradata Studio | Topic | Terdata Studio Express laggy on mac | Hi ,
I am using Teradata studio on mac and the typeing on the tool can be very laggy.
my OS version El Capitan 10.11.6
Teradata Studo Express 15.11
I searched on the this w... |
| 59636 | 04 Sep 2016 @ 02:39 PDT | mrjkirkpatrick | Database | Reply | Grouping while combining Date and Hour | Thank you, very helpful. Grouping by the two columns does seem easiest, though I'll try the other options as well.
|
| 59635 | 04 Sep 2016 @ 06:13 PDT | ak.sabale@gmail.com | Database | Reply | Sql to delete duplicates in Teradata |
Hi....
"How to remove duplicate more than one records from given table. table as tbl1
emp_id,emp_fname,emp_lname
1,a,b
2,a,b
2,a,c
3,c,b
3,f,h
i want output ... |
| 59634 | 04 Sep 2016 @ 06:06 PDT | Dinesh1975 | Connectivity | Topic | IP address based access to TD. | Please Can anyone let me know how to implement IP address based access to TD.
|
| 59633 | 03 Sep 2016 @ 11:42 PDT | pandit | Database | Topic | Teradata block storage | Hi All,
This is my first post :). So pardon me in case of any mistake.
I have been reading the teradata storage architecture in detail. Recently found very interesting article explaining ho... |
| 59632 | 03 Sep 2016 @ 09:20 PDT | dnoeth | Database | Reply | DBC Diskspace, | Wow, less than 1 percent for dbc, that's definitely way too low.
What's the % perm space in use?
|
| 59631 | 03 Sep 2016 @ 06:27 PDT | mohdsameed | Aster | Reply | Aster Management console (AMC) is not working for Aster Express | I am also getting the same issue. I have followed all the step as per document. Could you please let me know how did you resolve the issue?
|
| 59630 | 03 Sep 2016 @ 01:43 PDT | dnoeth | Database | Reply | Grouping while combining Date and Hour | The easiest way is to group by two columns:
CAST(row_added_ts AS DATE), EXTRACT(HOUR FROM row_added_ts)
You can also cast to a string, but your format will not allow correct sorting:... |
| 59629 | 02 Sep 2016 @ 07:37 PDT | Dinesh1975 | Database | Reply | DBC Diskspace, | 475G in 80 TB system.
|
| 59628 | 02 Sep 2016 @ 06:21 PDT | mrjkirkpatrick | Database | Topic | Grouping while combining Date and Hour | Hello,
I couldn't find exactly this question among the great date/time posts on the forum.
I have a date field (row_added_ts) with the format: "12/29/2014 6:34:42 PM"
My end goal i... |
| 59627 | 02 Sep 2016 @ 06:04 PDT | krishna1985 | Database | Reply | Insert taking long | Hi Dieter, thanks I will try to make all tables as multiset and will try to make another column as Primary Index. Thanks Sir..
|
| 59626 | 02 Sep 2016 @ 05:15 PDT | feinholz | Tools | Reply | File Writer operator writing out 0 for decimal columns with precision greater than 18. | Ok, if the "issue" that we fixed is what I think, these are the releases in which the issue was resolved:
14.10.00.014
15.00.00.001
|
| 59625 | 02 Sep 2016 @ 03:54 PDT | xinyuzhang | Teradata Studio | Topic | Option "User Choice (includes DBC)" not available in Teradata Studio 15.11 | Hello:
I installed Teradata Studio 15.11. For Data Source Explorer to list less objects, from Windows--Perferences--Teradata Datatool Preferences -- Data Source Explorer Load Preference, I try to ... |
| 59624 | 02 Sep 2016 @ 01:57 PDT | dnoeth | Database | Reply | Creating a Dynamic YoY Date Range in Case Statement for Current Quarter QTD | You can apply TRUNC & TO_CHAR like this:
CASE
WHEN date between TRUNC(CURRENT_DATE-1, 'Q') AND CURRENT_DATE-1
THEN TO_CHAR(CURRENT_DATE-1, '"Q"Q"_"yy... |
| 59623 | 02 Sep 2016 @ 12:12 PDT | firstcaptain | Teradata Studio | Reply | Teradata Studio 15.10.01.01 on Mac OS X -- Hangs | When I opened up the workspace there wasn't much there so I tried again ... and it seemed to work ... I am remote connecting via VPN so maybe there is a firewall issues in the office .. Thanks ... |
| 59622 | 02 Sep 2016 @ 12:06 PDT | Private Forum |
| 59621 | 02 Sep 2016 @ 12:05 PDT | feinholz | Tools | Reply | File Writer operator writing out 0 for decimal columns with precision greater than 18. | I am trying to look up when this was fixed.
Since it looks like several people are having issues, I need to know what version of TPT everyone on this thread is running.
|
| 59620 | 02 Sep 2016 @ 11:08 PDT | fgrimmer | Teradata Studio | Reply | Unable to connect to the database using Teradata Studio Express. | Akshay, Teradata Studio Express is meant for running queries and exporting result data. You will want to download our Teradata Studio product. It includes all the functionality of Studio Express, p... |
| 59619 | 02 Sep 2016 @ 11:05 PDT | fgrimmer | Teradata Studio | Reply | Teradata preferences for new connection profile type missing | Steven, Glad you found it. We have resolved an issue with the execute options being disabled in our upcoming 15.12 release. Using the Tools>Execute All is causing the wrong SQL Editor. It ... |
| 59618 | 02 Sep 2016 @ 10:25 PDT | Fred | Database | Reply | I can't execute an SP that calls another SP inside | For CREATE / REPLACE PROCEDURE, the CREATOR must have permission to execute any DML statements within the procedure (including CALL).
But the OWNER (database in which the procedure is de... |
