All forum activity

#DateUserForumTypeThreadPost
5964205 Sep 2016 @ 01:28 PDTjingguoTeradata StudioReplyTerdata Studio Express laggy on macI 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...
5964104 Sep 2016 @ 11:48 PDTjingguoTeradata StudioReplyTerdata Studio Express laggy on macwhen 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..."
5964004 Sep 2016 @ 11:39 PDTSoumyatgDatabaseReplyMerge into operationThanks 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...
5963904 Sep 2016 @ 10:57 PDTjingguoTeradata StudioReplyTerdata Studio Express laggy on macIf I close the teradata studio express and open it again, the laggy will disappear.
5963804 Sep 2016 @ 10:05 PDTjingguoTeradata StudioReplyTerdata Studio Express laggy on macI 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"...
5963704 Sep 2016 @ 10:03 PDTjingguoTeradata StudioTopicTerdata Studio Express laggy on macHi ,   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...
5963604 Sep 2016 @ 02:39 PDTmrjkirkpatrickDatabaseReplyGrouping while combining Date and HourThank you, very helpful. Grouping by the two columns does seem easiest, though I'll try the other options as well.  
5963504 Sep 2016 @ 06:13 PDTak.sabale@gmail.comDatabaseReplySql 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 ...
5963404 Sep 2016 @ 06:06 PDTDinesh1975ConnectivityTopicIP address based access to TD.Please Can anyone let me know how to implement IP address based access to TD.
5963303 Sep 2016 @ 11:42 PDTpanditDatabaseTopicTeradata block storageHi 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...
5963203 Sep 2016 @ 09:20 PDTdnoethDatabaseReplyDBC Diskspace, Wow, less than 1 percent for dbc, that's definitely way too low. What's the % perm space in use?
5963103 Sep 2016 @ 06:27 PDTmohdsameedAsterReplyAster Management console (AMC) is not working for Aster ExpressI 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?
5963003 Sep 2016 @ 01:43 PDTdnoethDatabaseReplyGrouping while combining Date and HourThe 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:...
5962902 Sep 2016 @ 07:37 PDTDinesh1975DatabaseReplyDBC Diskspace, 475G in 80 TB system.
5962802 Sep 2016 @ 06:21 PDTmrjkirkpatrickDatabaseTopicGrouping while combining Date and HourHello, 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...
5962702 Sep 2016 @ 06:04 PDTkrishna1985DatabaseReplyInsert taking longHi Dieter, thanks I will try to make all tables as multiset and will try to make another column as Primary Index. Thanks Sir..  
5962602 Sep 2016 @ 05:15 PDTfeinholzToolsReplyFile 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  
5962502 Sep 2016 @ 03:54 PDTxinyuzhangTeradata StudioTopicOption "User Choice (includes DBC)" not available in Teradata Studio 15.11Hello: 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 ...
5962402 Sep 2016 @ 01:57 PDTdnoethDatabaseReplyCreating a Dynamic YoY Date Range in Case Statement for Current Quarter QTDYou 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...
5962302 Sep 2016 @ 12:12 PDTfirstcaptainTeradata StudioReplyTeradata Studio 15.10.01.01 on Mac OS X -- HangsWhen 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 ...
5962202 Sep 2016 @ 12:06 PDTPrivate Forum
5962102 Sep 2016 @ 12:05 PDTfeinholzToolsReplyFile 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.
5962002 Sep 2016 @ 11:08 PDTfgrimmerTeradata StudioReplyUnable 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...
5961902 Sep 2016 @ 11:05 PDTfgrimmerTeradata StudioReplyTeradata preferences for new connection profile type missingSteven, 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 ...
5961802 Sep 2016 @ 10:25 PDTFredDatabaseReplyI can't execute an SP that calls another SP insideFor 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...

Pages