All forum activity

#DateUserForumTypeThreadPost
5946928 Aug 2016 @ 04:00 PDTFredDatabaseReplySum distinct records in a table with duplicates How about count(distinct case when a.header_comptia_cd = 'B92' then a.notif_id else NULL end) - 1 /* Don't include NULL in the count */ as B92_Sum  
5946828 Aug 2016 @ 12:28 PDTtisenhartTeradata Database on AWSTopicv15 express or community edition in EC2 I was trying to run the TD v15 express or community edition on vmware player in EC2 windows server 12, for some simple TD JDBC connectivity tests,  but i get hypervisor role errors and it does...
5946728 Aug 2016 @ 06:42 PDTToddAWalterDatabaseReplyInserting into table using multiple common table expressions CTETeradata only supports one WITH. But within the one WITH it is possible to specify as many CTEs as desired.
5946628 Aug 2016 @ 06:02 PDTDinesh1975DatabaseTopicMAX SPOOL BY AMPI am receiving the alert from viewpoint " Max spool by AMP".  60.19%.  Can you please let me know how to resolve it.
5946528 Aug 2016 @ 04:58 PDTrychitreDatabaseTopicMerge different rows in one rowI have huge data as below. ‘Act_dt,cust_id and cust_line_id’ should be unique key. act_dt cust_id cust_line_id flg1 flg2 flg3 metric1 metric2 met...
5946428 Aug 2016 @ 03:49 PDTSQLfan123DatabaseTopicFiltering results of concatenationHi Everyone! I'm having trouble with filtering concatenation results in Teradata. I'm using the following syntax "EXTRACT(YEAR from saledate)||EXTRACT(MONTH from saledate) AS date_num...
5946327 Aug 2016 @ 11:39 PDTbmsouthernDatabaseTopicInserting into table using multiple common table expressions CTEHi, I'm wondering if someone has a workaround for performing an insert from a select statement inside of a CTE.  My CTE has multiple 'with' statements and from what I've been ...
5946227 Aug 2016 @ 09:44 PDTtxwyldeDatabaseTopicSum distinct records in a table with duplicates I have a table that has some duplicates. I can count the distinct records to get the Total Volume. When I try to Sum when the CompTia Code is B92 and run distinct is still count...
5946127 Aug 2016 @ 09:05 PDTGlassDatabaseReplyCursors in stored proceduresUse: Dynamic Result sets 2, Declare and open a second cursor.   Rglass
5946026 Aug 2016 @ 10:30 PDTkhawar.ameerDatabaseReplyEXPORTING SELECT QUERY OUTPUT TO A TEXT FILEDear Mr. ulrich, appologies for writing in uppercase. I am using this query in Microsoft PowerQuery through ODBC connection. KAM
5945926 Aug 2016 @ 04:00 PDTToddAWalterDatabaseReplyPPIIt is generally better to start a new thread for a new question...   It is correct that a UPI cannot be defined when it does not contain the partitioning column. This is because enforcing th...
5945826 Aug 2016 @ 02:47 PDTpinkus05Teradata Database on VMWareReplyODBC on Teradata on VMThanks Johannes! I did try to install it with nodeps, so now I have: # rpm -qa | egrep -i "tdodbc|tdicu|teragss" TeraGSS_linux_x64-15.10.02.04-1 tdicu-15.00.00.00-1 tdodbc1510-15.10....
5945726 Aug 2016 @ 02:27 PDTTDHS9ToolsReplyTPT Wizard driver errorI'm having the same issue on 2 different machines. One with Ver 15.00 and other with 15.10. I've updated the client software with latest version on one of the machines as below. Database ...
5945626 Aug 2016 @ 10:49 PDTDeepakjiDatabaseReplyCursors in stored procedures REPLACE PROCEDURE proc () DYNAMIC RESULT SETS 1 BEGIN   DECLARE c CURSOR WITH RETURN ONLY FOR   SELECT * FROM dbc.TablesV;   OPEN c; END; ...
5945526 Aug 2016 @ 10:49 PDTulrichDatabaseReplyEXPORTING SELECT QUERY OUTPUT TO A TEXT FILEWriting in uppercase is sometimes considered as crying loud and not the best habit in forums ;-)... The most important info is missing in your post - which utility / tool do you use to run this qu...
5945426 Aug 2016 @ 09:48 PDTPrivate Forum
5945326 Aug 2016 @ 09:37 PDTToddAWalterAnalyticsReplyQuery_Discussion_HELPPlease provide query and Explain.
5945226 Aug 2016 @ 09:25 PDTToddAWalterDatabaseReplyTeradata: No more room in journal table for novaquality.journalsA SHOW table on the target table will showthe database location for the journals. It is possible the journals are in a different database that is out of space even if the database containing t...
5945126 Aug 2016 @ 08:34 PDTFredDatabaseReplyTeradata: No more room in journal table for novaquality.journalsIn Teradata Studio, use the "Move Space" tool in the Teradata Administrator perspective.
5945026 Aug 2016 @ 06:07 PDTjuanalfonsoDatabaseTopicTeradata: No more room in journal table for novaquality.journals Hello,   When I tried to insert more than a million of rows in a table, I got the following error: No more room in journal table for novaquality.journals I have a...
5944926 Aug 2016 @ 05:01 PDTPrivate Forum
5944826 Aug 2016 @ 03:26 PDTkamlesh114DatabaseReplyPPIPlease comment..
5944725 Aug 2016 @ 10:51 PDTkhawar.ameerDatabaseTopicEXPORTING SELECT QUERY OUTPUT TO A TEXT FILEHELLO, CAN ANY TELL ME HOW TO EXPORT RESULT OF FOLLOWING QUERY TO A TEXT FILE SELECT ACCOUNT_NAME, ACCOUNT_TITLE FROM DB_BRANCH.ACCOUNTS WHERE BRANCH_PARTY_ID = '5555' ...
5944625 Aug 2016 @ 10:07 PDTKuldeepg92DatabaseTopicextract time from timestamp(6)Hi, How to extract TIME from TIMESTAMP(6). milliseconds are needed to get trimmed. Thank you
5944525 Aug 2016 @ 05:12 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI was on vacation for a while, but I have been avoiding double clicking on words over the course of a week or so and am convinced that that was the issue.  I'm glad that the issue is fixed...

Pages